Re: Sending data in table, multiple rows, via mail()

Thank you for your *extreme* kindness... I do not know where to begin to make this happen. I created a variable and ran the entire do while loop to read contents of the table and tried storing them in the variable, which could be used as Content of the mail. However, i just get the Last Row in my DB Table sent in mail.. not all the rows. Following is part of the code i'm using, and it could be absolutely wrong, but that's all i know.. <? $db = mysql_connect("localhost","user", "pwd"); mysql_select_db("tbl",$db); $result = mysql_query("SELECT * FROM cart where sid='$s'",$db); $realcontent=" if ($myrow = mysql_fetch_array($result)) { do { $myrow[pid]<br> $myrow[nm]<br> $myrow[q]<br> } while ($myrow = mysql_fetch_array($result)); } "; $to = "thomasedisonjr@yahoo.com"; $subject = "Purchase order Website"; $from = "Purchase Order"; $stuff = " Name : $name\n Phone : $phone\n Fax : $fax\n Email : $email\n Address : $address\n Country : $country\n Order:\n\n $realcontent\n\n"; mail($to,$subject,$stuff,$from); ?> __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com