I was in need of a simple house-keeping script, but couldn’t find anything simple. So I knocked this, simplified, up:
<?php
$to = 'to@me.com';
$subject = 'SQL results';
$headers = 'From: me@me.com' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
$dbname = 'name'; // The name of the database
$dbuser = 'user'; // Your MySQL username
$dbpass = 'password'; // ...and password
mysql_connect("localhost",$dbuser,$dbpass);
mysql_select_db($dbname) or die( "Unable to select database");
$query = "select 1 as id, 2 as name, 3 as something";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
$message = "";
while ($i < $num)
{
$id=mysql_result($result,$i,"id");
$name=mysql_result($result,$i,"name");
$something=mysql_result($result,$i,"something");
$message.= $id. " ". $name . " " . $something . "\n";
$i++;
}
if ($num > 0)
{
mail($to, $subject, $message, $headers);
}
?>
Replace variables with suitable values!