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, James, James, Mike ...
> I would like to call: Bob, Jan, Mike, James ... Any Idenas

I suspect you mean the mysql field name is 'iName', not '$iname' ($iName 
being the PHP variable name).


select distinct(iName) from tablename

and loop through those result sets.

Michael Kimsal
PHP Training Courses

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to