emailing multiple variables

[thrakath]

I am using php to draw values from a mysql database. I currently have a page which draws multiple entries depending on a reference number.

What i'm trying to do is to email these entries to someone. their email needs to be selected from the database to, which i can do. What i can't do is get multiple variables into an email in any sort of legable order.

I am using a while do loop to do this. Someone suggested using an array and storng the data that way, but i have never had any luck with the counter side of arrays and the data coming out of the db is not always the same ammount.

Any help would be much appreciated.

Cheers

[cgraz]

while ($row = mysql_fetch_array($query)) {

$subject = "Message Subject";
$to_address = $row["email"]l
$msg = "Field 1: " . $row["field1"] . "\n";
$msg .= "Field 2: " . $row["field2"] . "\n";
$msg .= "Field 3: " . $row["field3"] . "\n";

mail($to_address, $subject, $msg);

// end while loop
}

I think you get the picture. 😉

Cgraz