Advise of new records

[cswales]

Hi
I am trying to create a script that will query my database for records input within that day and to send the formatted list via email to a list of email addresses from a database.

Any help with this is appreciated.

[bastien]

$date = date("Y-m-d");
$sql = "select * from table where date_format(date,'%Y-%m-%d') = '$today'";

$result = mysql_query($sql);
$message = '';  //default and initilize variable
if (($result)&&(mysql_num_rows($result)>0))
{
   while ($rows = mysql_fetch_array($result))
  {
     $message .= mysql_field_name($result,0).':'.$rows[0].'\n' ; \\add whatever fields you want


  }

}else{
   $message = "No results today";
}
$to = "[e-mail]";
$subject = "New data entered";

//build the headers
$headers = "MIME-Version: 1.0\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\n";
$headers .= "X-Priority: 1\n";
$headers .= "X-MSMail-Priority: High\n";
$headers .= "X-Mailer: PHP\n";
$headers .= "From: \"Site Admin <[e-mail]>\n";

mail($email, $subject, $message, $headers);
?>