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, Bob,
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 excample
if
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 correct.
3 matches
Mail list logo