GROUP BY column ??? For example if you want the count(*) of each value do like this SELECT column, count(*) from 'tablename' GROUP BY column ;
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 15, 2002 8:17 AM Subject: [PHP] returning unique values in columns > Is there any way to run a query in mysql that retuns unique values in a > column? For example, say i had this colum: > > Column: > --------- > Fashion > --------- > Basics > --------- > Fashion > --------- > Plus > -------- > Plus > --------- > > but I only want it to return unique values - in this case I would only > want Fashion, Basics, Plus - instead of the Fashion, Basics, Fashion, > Plus, Plus I would get if I had run: SELECT column FROM tblname; > > any help would be greatly appreciated... > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
