If your action of sending email to the users is not very often, you can select email from comment into a tmp table, then make the users data table joining the temp one, and this should be more efficacious. Best regards, Shiqi Yang -----Original Message----- From: W Luke [mailto:wtluke@xxxxxxxxx] Sent: Monday, July 04, 2005 12:18 AM To: PHP Lists Subject: Group By problems Hi, I used to have problems with this in Cold Fusion - and I'm still struggling this time in PHP! Very basic. Looping over 2 tables - an email table, and a data-table. I'm using * just for ease for the time being: SELECT * FROM f_c_users,f_comments WHERE fcEmail=cemail GROUP by fcEmail If there are more than one records in the data table *per* email, then I want to group them into one email per user. Instead of sending 10/20/100 emails per person for each record in the data-table. So I just want to collate everyone's data into one email. Any thoughts welcome! Cheers -- Will -- The Corridor of Uncertainty -- -- http://www.cricket.mailliw.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
