Re: [PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T

Hey, Thanks for replying. Nope, that didnt work, but i modified my search terms on google and kept on trying with different search terms and got the solution here: http://dbforums.com/arch/230/2002/11/623223 Cheers, -Ryan On 2/10/2004 3:14:21 AM, Shaunak Kashyap ([EMAIL PROTECTED]) wrote: > Try

Re: [PHP] php with mysql COUNT, DISTINCT syntax, might be a bit 0T

Try this: "SELECT COUNT(*), order_number FROM " . $prefix . "_purchases GROUP BY order_number" as your query. Shaunak - Original Message - From: "Ryan A" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 09, 2004 8:36 PM Subject: [PHP] php with mysql COUNT, DISTINCT sy