On Tue, Feb 10, 2009 at 2:41 PM, revDAVE <c...@hosting4days.com> wrote: > 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] >
SELECT DISTINCT Category FROM contacts Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
