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 sure I understand your question (samples are always nice), but I'd suggest looking into "GROUP BY" or "SELECT DISTINCT". miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php