Creating A Unique List With Table Query

From: 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]

« previous php.general (#288079) next »