Keep the context of the email in a variable, add the details of the product in each loop. Then you can call mail() with the complete order information.
PS. Donīt you think itīs better to query the db only once asking the details for all the products ordered? Bruno Pereti. ----- Original Message ----- From: "Boa Constructor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 11, 2003 2:01 PM Subject: [PHP-DB] Email confirmation? > Greetings every1 ........ I'm wondering how I can send the details of an > order to an email address. I have a foreach loop which loops through an > array and each time round the loop it runs a query on the database to get > product details. If for instance they ordered 5 different items then I > would need to loop 5 times to get all the product information. The way I > see it, I can't make a call to the mail() function within the foreach loop > as that would send out an email for each product ordered. > > Any ideas how to send all the order information all in one email? > > Cheers for any ideas, > > Graeme :) > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
