Re: [Bulk] [PHP] Creating A Unique List With Table Query

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