Re: [PHP] Only one value from a msSQL field.

On Wed, 19 Jun 2002, Philip J. Newman wrote: > Only one value from a msSQL field. > I have many values the same in a field and would like to know how i can select one >of each (not mating). > > $sql = "SELECT * FROM brands WHERE 1 ORDER BY `sId` DESC LIMIT 6"; > > lists everything .. I'm not s

[PHP] Only one value.

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 l