Email MySQL array results

[djones]

How can I email the results of a MySQL array (loop). For example:

[code]
while ($myrow = mysql_fetch_array($result)){

$field = $myrow["field"]; // Will return multiple rows

}
[/code]

Now I need to mail the results above only once. I know how to use the mail function.

[tomfmason]

You could do something like this.

[code=php:0]
$field = "begin list<br />";
while ($myrow = mysql_fetch_array($result)){
   $field .= $myrow['field'] . '<br />';.
}

$to = "someone";
$subject = "something";
$message = 'The is a list of someting: ' . $field;
//now send the message
[/code]

Hope that helps,
Tom

[djones]

Yes that worked. Thanks.