Daily Grind

$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++;
}