RE: [PHP] Need desperate help with query

2007-01-31 Thread Peter Lauri
SELECT COUNT(*) AS thecount FROM table1 LEFT JOIN tabel2 ON (table1.col1 = table2.col2) GROUP BY table1.col3 ORDER BY thecount; It might give you some hints... Best regards, Peter Lauri www.dwsasia.com - company web site www.lauri.se - personal web site www.carbonfree.org.uk - become Carbon Free

RE: [PHP] Need desperate help with query

2007-01-31 Thread Tim
> -Message d'origine- > De : Skip Evans [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 31 janvier 2007 17:26 > À : PHP-General > Objet : [PHP] Need desperate help with query > > Okay, so SQL questions shouldn't come to the list, You are aware of that too eh? So why mail here? > but I a