RE: [PHP] Newman Says: Only one value from a msSQL field.
| From: | John Holmes | Date: | Sun, 02 Jun 2002 02:17:44 +0000 |
| Subject: | RE: [PHP] Newman Says: Only one value from a msSQL field. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-100269@lists.php.net to get a copy of this message | ||
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:php@philipnz.com]
> Sent: Tuesday, June 18, 2002 8:39 PM
> To: php-general@lists.php.net
> 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
>