Re: Email Selected Data

Ade, You can try something like this: while (list($column_name, $row_value) = each($row)) { echo "$column_name,$row_value <br>" ; } // 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 other array elements such as MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH. see: http://www.php.net/manual/en/function.mysql-fetch-array.php Best regards, Andrew --------------------------------------- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com On 2/4/01 9:01 PM, "David Robley" <huntsman@hermes.nisu.flinders.edu.au> wrote: > On Mon, 5 Feb 2001 07:01, Website4S@aol.com 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:ade@address.com"); >> >> 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.