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 Wealth

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 Africa - Q