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.";

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

MySQL results in email

email, php

PHP