Re: [PHP] WEALTH ON THE WEB!

mm. I wonder what this guy is up to : 8-) - Original Message - From: Noel Hadfield <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 20, 2001 11:17 AM Subject: [PHP] WEALTH ON THE WEB! > Get a FREE copy of the exciting 48-page booklet "Inside Secrets to Wealt

Re: [PHP] Super SQL problem! Please advise!

Sandeep try this SELECT d.id, d.thedate, d.topic, d.entry, count(c.id) AS comments FROM diary d left outer join comments c on (d.id = c.id) WHERE d.month='$month' GROUP BY c.id ORDER BY d.id DESC " Cheers _____ Graham Reeves Consultant PQ Af