put while loop contents into one variable

[jeff5656]

Instead of echoing out this list of records, I want to put everything inside this while loop into $message so I can email the list.  How do I do this?

Here's the code that echoes it out to the screen:

$query2 = "SELECT * FROM `gpu` WHERE `signoff_status` = 'a' and `attg` = '". $whoto ."' ";

$result2 = mysql_query ($query2) or die ("Invalid query: " . mysql_error ());
while ($row2 = mysql_fetch_assoc ($result2)) {
echo "Patient:". $row2['patient'] . " MRN:  " . $row2['mrn'];
<br>
}

[rhodesa]

<?php
$message = "";
$query2 = "SELECT * FROM `gpu` WHERE `signoff_status` = 'a' and `attg` = '". $whoto ."' ";
$result2 = mysql_query ($query2) or die ("Invalid query: " . mysql_error ());
while ($row2 = mysql_fetch_assoc ($result2)) {
  $message .= "Patient:". $row2['patient'] . " MRN:  " . $row2['mrn'] . "\n<br>";
}
?>

[jeff5656]

Ok, will this keep appending the additional records into $message untl the while loop is complete?  It won't be that each record will overwrite the value of $message

[rhodesa]

nope, the . in the .= appends instead of overwrites. it's shorthand for:

$message = $message . "some more text";