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). try select distinct(iName) from tablename and loop through those result sets. Michael Kimsal http://www.tapinternet.com/php/ PHP Training Courses 734-480-9961 -- 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]
