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

2009-02-10 Thread revDAVE
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] -

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

2009-02-10 Thread Stephen
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 : Ho

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

2009-02-10 Thread Per Jessen
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

2009-02-10 Thread Andrew Ballard
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

[PHP] Creating A Unique List With Table Query

2009-02-10 Thread revDAVE
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. Qu