mail multiple records in 1 message

[Anon]

hi,
i am trying to email all the records from a specific query into 1 message. I tried to use while ($myrow = mysql_fetch_array($result)){
etc,
however by using an array it will send all the values but in multiple messages,
is there anyway to send an email this way?
thanks

[Anon]

loop through the results of the query and put them in a variable. Then just call mail() after the loop is done and put the variable with all the data as the message.

[Anon]

thanks for the quick reply,
i can get the array to be looped, however when I try to put them into a variable, only one record is mailed. Please could you tell me how to get a whole array into one variable?
thanks

[fandelem]

/
Here is an example to select every distinct category
from the table lyrics, compile all of them into one variable
and then mail it.
/
$categories = ""; / good habit 🙂 */
$sql = "SELECT DISTINCT category from {$DB_CONF["lyrics"]} ";
$sql_result = mysql_query($sql) or die ("Couldn't execute query. (category()) ".mysql_error());
while ($row = mysql_fetch_array($sql_result))
{
$categories .= $row['category'];
}
$msg = "Here are a listing of categories:\n\n";
$msg .= $categories;
$email = "[e-mail]";
$admin = "[e-mail]"; // reply-to, needed!!
$title = "Test Title";
$from = "From: LyricBot\nReply-to: $admin";
mail($email, $title, $msg, $from);

cheers,

kyle

[Anon]

thanks for the help,
managed to get it to work using your code,
cheers