RE: [PHP] Email Selected Data

2001-02-05 Thread 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 , "Fro

Re: [PHP] Email Selected Data

2001-02-04 Thread Andrew Hill
Ade, You can try something like this: while (list($column_name, $row_value) = each($row)) { echo "$column_name,$row_value " ; } // loop thru each row and get an array of values for each row, listing them // as name:value pairs the above would be for mysql_fetch_array($array, MYSQL_ASSOC) for o

Re: [PHP] Email Selected Data

2001-02-04 Thread David Robley
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 =

Re: [PHP] Email Selected Data

2001-02-04 Thread Christian Reiniger
On Sunday 04 February 2001 21:31, [EMAIL PROTECTED] wrote: > 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'], Re-read the documentation for "printf". You want