[PHP] Storing mysql result into a pointer (or something)

[Bård Tommy Nilsen]

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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php