Location: PHPKode > projects > Matt's March Madness > trunk/admin/emailatstart.php
include 'functions.php';

$brackets = "SELECT person, email, id, paid FROM `brackets`";
$brackets = mysql_query($brackets,$db);

$meta = "SELECT email, name, mail,cut FROM `meta` WHERE id=1";
$meta = mysql_query($meta,$db); //grabs administrator's email
$meta = mysql_fetch_array($meta);
$adminEmail = $meta['email'];

$subject = "March Madness Has Begun";

while ($row = mysql_fetch_array($brackets, MYSQL_ASSOC)) {

	$userEmail = $row['email'];
	// prepare administrator email body text
	$body = "The NCAA basketball tournament has begun.  Thank you for taking part in this year's pool.";
    $link = "http://ncaa.botag.org/view.php?id=" . $row['id'];
    $body .= "  You can view your bracket or print it out at " . $link;
    $body .= " and you can watch the standings update as the tourney progresses at http://ncaa.botag.org/choose.php.  ";
	if ($row['paid'] < 1) {
		$body .= "\n\nNOTE:\nThis bracket has not been paid for.  Please pay Brian (6-308) as soon as possible.  Your bracket will not show up in the standings until payment is received.";

	/*echo $userEmail;
	echo "\n\n";
	echo $subject;
	echo "\n\n";
	echo $body;
	echo "\n\n";*/
	mail($userEmail, $subject, $body, "From: <$adminEmail>");

	//redirects to a confirmation notice
	$_SESSION['success'] = "Emails have been sent";
Return current item: Matt's March Madness