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
