revDAVE wrote:
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?
Check out the "DISTINCT" keyword in the SELECT documentation.
Also, do you have a "Category" table?
Stephen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
