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".


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to