Email DataBase Results
| From: | Robert Pruitt | Date: | Mon, 21 Apr 2003 19:59:42 +0000 |
| Subject: | Email DataBase Results | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-144712@lists.php.net to get a copy of this message | ||
$query = "select * from table";
$result = mysql_db_query("$dbName", $query);
while ($r = mysql_fetch_array($result)) {
$variable1 = $r["variable1"];
$variable2 = $r["variable2"];
$variable3 = $r["variable3"];
}
mail("joecool@example.com", "My Subject", "$variable1 - $variable2 -
$variable3");
What is the best way to include the results of this query into the
mail() function?
The above trial will not give full results.