Re: Email Selected Data

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. -- 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