< ?
$today=date("Y-m-d");
 
$db_host = "localhost";
$db_user = "dbusername";
$db_passwd = "password";
$db_db = "database";
 
mysql_connect("$db_host","$db_user","$db_passwd");
mysql_select_db("$db_db");
 
$result=mysql_query("select comment_author,comment_author_email,comment_author_url,comment_content, comment_date from wp2_comments where comment_author_email NOT IN (SELECT email FROM commentcontest) AND comment_author !='shoemoney' AND comment_approved=1 AND comment_post_id =(select id from wp2_posts where post_status ='publish' AND post_type = 'post' AND  post_date like '$today%' order by post_date limit 1) order by rand() limit 1");
 
while($row = mysql_fetch_object($result))
                {
 
                $author = $row->comment_author;
                   $email = $row->comment_author_email;
                   $url = $row->comment_author_url;
                   $content = $row->comment_content;
                   $comment_date = $row->comment_date;
                }
 
if (!$email=='') {
 
$content=addslashes($content);
$code =md5($email);
 
$subject = "$today ShoeMoney Comment Contest Winner $code";
 
        $headers = "Return-Path: annasemail@shoemoney.com\r\n";
        $headers .= "From: Anna <annasemail @shoemoney.com>\r\n";
        $headers .= 'Bcc: Jeremy <jeremy @shoemoney.com>' . "\r\n";
 
$message = "Dear $author,
 
Congratulations!  You are the randomly selected winner for your comments written on a shoemoney.com blog post on $today. You have won a ShoeMoney t-Shirt and a chance at this months grand prize! \nTo Claim your t-shirt Please reply to this email with your shirt size, style of shirt (male or female Small to XXXL),  and your mailing address.\n We will ship them to you free of charge anywhere in the world!  Please respond to this email within 48 hours with your address if you wish to claim your free shirt!\nCongratulations and good luck at winning this months grand prize.  For more information check http://www.shoemoney.com/commentcontest/
 
Please note - We ship out shirts on the first and 15th of each month. \n
 
Also please keep the subject line with the code intact so we can verify its authenticity!i\n
 
Thanks for your contribution to the ShoeMoney Blog!  We appreciate your support and input!\n
 
Jeremy Schoemaker AKA ShoeMoney";
 
        mail($email,$subject,$message,$headers);
 
mysql_query("INSERT INTO commentcontest(doc,author,email,url,content) VALUES('$today','$author','$email','$url','$content')")  or die(mysql_error());
 
print "$author $email $url $content $comment_date";
} else {
 
        die("no data\n\n");
}
?>
</jeremy></annasemail>

< ?php
$db_host = "localhost";
$db_user = "dbusername";
$db_passwd = "password";
$db_db = "db";
 
mysql_connect("$db_host","$db_user","$db_passwd");
mysql_select_db("$db_db");
$contestdate=date('F Y');
?>
<table>
<tr>
<td>Date</td>
<td>Winner Name</td>
<td>Comment</td>
</tr>
 
< ?php
$result=mysql_query("select * from commentcontest where dtime > '2008-12-01 00:00:00' order by dtime DESC");
 
while($row = mysql_fetch_object($result))   {
 
                $doc=$row->doc;
                        $author = $row->author;
                $url = $row->url;
                $content = $row->content;
                $comment_date = $row->comment_date;
print "
<tr>
<td>$doc</td>
<td><a href=\"$url\">$author</a></td>
<td>$content</td>
</tr>
 
";
}
echo  "</table>
 
";
?>