Creating A Unique List With Table Query
| From: | revDAVE | Date: | Tue, 10 Feb 2009 19:41:52 +0000 |
| Subject: | Creating A Unique List With Table Query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-288079@lists.php.net to get a copy of this message | ||
Newbie question
Hi Folks,
I would like to be able to query a table, and return only the unique values
from a particular field. For example: to get all contents from the category
field from the contacts table:
Query = ....
SELECT Category FROM contacts
But this will produce many duplicates.
Question : How do I filter the query to only produce unique values?
I was looking at: array_unique but I am not sure how to implement this in a
MYSql table query....
Any help would be appreciated - thanks Dave
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09]