On Mon, 5 Feb 2001 07:01, [EMAIL PROTECTED] wrote:
> 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
I think your logic is wrong here, if you are trying to send one email with
all the results from the DB query in it.
Each time you run through the for loop, you are assigning a new value to
$contents, rather than appending new information to it. I think you need
$content .= printf(blah blah);
or without the printf complexity
$content .= "First Name: " . $array["FirstName"] . "\nLast Name: " .
$array["LastName"] . "\n";
You'ld need to ensure $content is empty before starting the for loop, of
course.
--
David Robley | WEBMASTER & Mail List Admin
RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/
AusEinet | http://auseinet.flinders.edu.au/
Flinders University, ADELAIDE, SOUTH AUSTRALIA
--
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]
