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]
