<?php
$DB_Server = "localhost"; //your MySQL Server
$DB_Username = "root"; //your MySQL User Name
$DB_Password = ""; //your MySQL Password
$DB_DBName = "site"; //your MySQL Database Name
$Connect = mysql_connect($DB_Server, $DB_Username, $DB_Password)
or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno());
$Db = mysql_select_db($DB_DBName, $Connect);


// Only edit above this line.
$query = "SELECT * FROM `emails` ORDER by `id` DESC LIMIT 20";
$result = mysql_query($query,$Connect);
while($row = mysql_fetch_assoc($result)){
$to      = $row['email'];
$id      = $row['id'];
$subject = 'Join Crusade Gaming Today!'; // Subject line of message
$message = "MESSAGE GOES HERE";
$from    = "newsletter@crusadegaming.net";
$headers = 'From: ' ."$from" . "\r\n" .
    'Reply-To: ' ."$from" . "\r\n" .
    'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $message, $headers);
}
mysql_query("DELETE FROM`emails` ORDER by `id` DESC LIMIT 400",$Connect);
$page = "newsletter.php";
$sec="60";
header("Refresh: $sec; url=$page");
?>