use: SELECT DISTINCT column FROM table
regards, Ewout de Boer ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 14, 2002 10:17 PM 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
