RE: [PHP] Email Selected Data

2001-02-05 Thread PHPBeginner.com
onday, 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=&#

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

[PHP] Email Selected Data

2001-02-04 Thread Website4S
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($dba