Query within Mail Function
| From: | James Meers | Date: | Tue, 20 Aug 2002 12:32:18 +0000 |
| Subject: | Query within Mail Function | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-15361@lists.php.net to get a copy of this message | ||
Hi,
Please bear with my limited knowledge of PHP...
Does anyone know if it is possible to code a sql query within the message part of the mail function,
e.g.:
mail( "$to_mail","$sumject","
$sql = mysql_query("select * from table")
or die("error with query\n");
while ($row = mysql_fetch_array($sql)) {
$db_name=$row["name"];
$db_email=$row["email"];
$db_age=$row["age"];
echo"$name - $email - $age";
}
" );
This obviously is wrong, does anyone know if its possible, if so, what is the right way of writing
it??
Cheers
James