<?
require_once('connect.php');
$query = "SELECT user_emails FROM tbl_users ORDER BY users_date desc";
$result = @mysql_query ($query) or die ("failed : ".mysql_error());
$num = mysql_num_rows ($result) or die ("failed : ".mysql_error());
if ($num > 0) {
echo "
There are currently $num user(s) to email to.</p>";
if(isset($_POST['mail_form'])) {
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
if($row['0'] && $subject && $message) {
mail($row['0'], $subject, $message);
}
}
}
}
mysql_free_result ($result);
} else {
echo '
There are no people to send news to, your site sucks.</p>';
}
mysql_close();
?>
<form name="mail" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="text" name="subject" />
<input type="text" name="message" />
<input type="submit" name="mail_form" value="Mail that news!" />
</form>