Storing mysql result into a pointer (or something)
| From: | Bård Tommy Nilsen | Date: | Sat, 08 Jun 2002 11:40:03 +0000 |
| Subject: | Storing mysql result into a pointer (or something) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-101265@lists.php.net to get a copy of this message | ||
I am trying to store several results from an mysql_query into an "int"
I want to produce several lines into $result, so i can include $result
Into my email, or is there a better way to do this ?
$query = mysql_query("select * from $table");
$number = mysql_numrows($query) ;
$i = 0;
while ($i < $number) {
$id = mysql_result($query,$i,"id");
$Name = mysql_result($query,$i,"Name");
## WHAT MUST I DO HERE ??? ##
$i++;
}
Echo "$result";
I will use the result to send an email
$FromName = "$Name";
$FromAddress = "$Email";
$ToAdress = "$ToAdress";
$message = '<b><br>
$result
';
mail($ToAdress." <".$ToAdress.">", $Subject, $message, "From:
".$FromName."
<".$FromAddress.">\nContent-Type: text/html; charset=iso-8859-1");