Re: [PHP] Re: Only one value.

2002-01-27 Thread Michael Kimsal
Mark Charette wrote: >> > > Almost right. DISTINCT is not a SQL function: > > select distinct iName from tablename > > would be the correct syntax. > > Seems to work fine on every version of MySQL I've used for the past few years, and I believe SQL Server 6.5 and 7, if memory serves corr

Re: [PHP] Re: Only one value.

2002-01-27 Thread Mark Charette
From: "Michael Kimsal" <[EMAIL PROTECTED]> > Philip J. Newman wrote: > > > Don't know is this is a Mysql problem or PHP, but I have a table with 100 records in it. One of the field names is $iName. > > > > When listing all the records I want only the 1st Uneak value to be displayed. > > > > For

[PHP] Re: Only one value.

2002-01-27 Thread Michael Kimsal
Philip J. Newman wrote: > Don't know is this is a Mysql problem or PHP, but I have a table with 100 records in >it. One of the field names is $iName. > > When listing all the records I want only the 1st Uneak value to be displayed. > > For excample > > if values where, Bob, Jan, Mike, James