I don't know about msSQL, but in mySQL you can do something like
$sql = "SELECT * FROM brands WHERE 1 GROUP BY field ORDER BY `sId` DESC LIMIT 6"; 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 .. > >ANy help would be cool. > >Phil > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
