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

On 2/10/2009 11:45 AM, "Andrew Ballard" wrote: > SELECT DISTINCT Category FROM contacts Thanks folks - that was perfect! On 2/10/2009 11:46 AM, "Stephen" wrote: > Also, do you have a "Category" table? > No Stephen I don't. -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -

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

revDAVE 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 > >

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

On Tue, Feb 10, 2009 at 2:41 PM, revDAVE 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