This has nothing to do with PHP. Subscribe to a database list.

Use DISTINCT or GROUP BY

---John Holmes...

> -----Original Message-----
> From: Philip J. Newman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 8:39 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Newman Says: Only one value from a msSQL field.
> 
> 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

Reply via email to