Re: Unique SQL query?????????????

From: Date: Tue, 11 Jun 2002 08:20:47 +0000
Subject: Re: Unique SQL query?????????????
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-19734@lists.php.net to get a copy of this message
Try adding 'distinct' before the field you are selecting. -Lisi At 01:42 AM 6/8/02 +0100, Georgie Casey wrote:
Is there any SQL command that will return a list of *unique* entries from a fied. ie only repeat one for duplicates i have a database of products, each having a category, and obviously a lot of products have the same category and I want to create an index of all the different categories. thanks -- Regards, Georgie Casey webmaster@filmfind.tv *************************** http://www.filmfind.tv Online Film Production Directory *************************** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


« previous php.db (#19734) next »