Posted By

jcroom on 08/19/09

Tagged

Versions (?)

Last Edited at 08/19/09 12:06pm

Statistics

Viewed 1118 times

Favorited by 2 user(s)

Related snippets

MySQL results in email

/ Published in: PHP

Take the contens from a table in MySQL and display it in an email

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function message()
{
 $m2 = '';
 $result = mysql_query("SELECT * FROM inventory WHERE count < 4");
 while($row = mysql_fetch_array($result))
  {
 
  $m2 .= $row['item']. ": " .$row['count'] . "<br>";
    }
return $m2;
}
 
 
 
$to = "[email protected]";
$subject = "My subject";
$from = "[email protected]";
 
 
$headers = "MIME-Version: 1.0" . "
";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "
";
 
$headers .= "From: $from";
$message = message();
mail($to,$subject,$message,$headers);
echo "Mail Sent.";