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.
PHP Training Courses
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]