W Luke wrote:
Hi,
I used to have problems with this in Cold Fusion - and I'm still
struggling this time in PHP!
This isn't a PHP-specific question, it's more a MySQL question. You
might want to try the MySQL mailing lists if you don't get a
satisfactory answer here.
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.
Unless you're using a very recent version of MySQL (4.1+) with the
GROUP_CONCAT function, I'd suggest just looping over the users table and
then looping over the data table separately inside the users loop.
Jasper
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
