Posted by W Luke on 09/28/57 11:20

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/

• Next in forum: Re: [PHP] Re: Templating engines
• Prev in forum: setting initial vlaue of optionbox
• Thread view: Group By problems

[Reply to this message]