Posted by "yangshiqi" on 09/28/55 11:20

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@gmail.com]
Sent: Monday, July 04, 2005 12:18 AM
To: PHP Lists
Subject: [PHP] 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

• Next in forum: Re: [PHP] Conversion of period and space for $_GET, $_REQUEST, etc. is rather senseless
• Prev in forum: Re: Help a Norwegian student!
• Thread view: RE: [PHP] Group By problems

[Reply to this message]