RE: [PHP] Email Selected Data

[PHPBeginner.com]

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:[EMAIL PROTECTED]");



Sincerely,

 Maxim Maletsky
 Founder, Chief Developer

 PHPBeginner.com (Where PHP Begins)
 [EMAIL PROTECTED]
 www.phpbeginner.com



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 5:32 AM
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]");

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]