RE: [PHP] Email Selected Data

you need to have the $content line with (.) operator: for ($i=0; $i<$num_rows; $i++) { mysql_data_seek($SQLResult, $i); $array=mysql_fetch_array($SQLResult); $content .= printf("First Name: %s\nLast Name: %s\n",$array['FirstName'], $array['LastName']); } mail($MAIL, "Order", $content , "From:ade@address.com"); Sincerely, Maxim Maletsky Founder, Chief Developer PHPBeginner.com (Where PHP Begins) maxim@phpbeginner.com www.phpbeginner.com -----Original Message----- From: Website4S@aol.com [mailto:Website4S@aol.com] Sent: Monday, February 05, 2001 5:32 AM To: php-general@lists.php.net Subject: [PHP] Email Selected Data Hi, I am selecting data using the below and trying to insert it into a mail, it does everything except send the data selected, anyone have an idea? $SQLStatement = "SELECT * FROM Orders Where Status='N' Order by OrderID"; $SQLConn = mysql_connect($host, $user, $pass); $db = mysql_select_db($dbase, $SQLConn); $SQLResult = mysql_query($SQLStatement); $num_rows=mysql_num_rows($SQLResult); for ($i=0; $i<$num_rows; $i++) { mysql_data_seek($SQLResult, $i); $array=mysql_fetch_array($SQLResult); $content=printf("First Name: %s\nLast Name: %s\n",$array['FirstName'], $array['LastName']); } mail($MAIL, "Order", $content , "From:ade@address.com"); I know it is working to a degree because it prints out the data on the resulting page and sends a blank email, it just doesn`t put it in the email. TIA Ade -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net