Re: Only one value from a msSQL field.
| From: | Miguel Cruz | Date: | Wed, 05 Jun 2002 18:00:27 +0000 |
| Subject: | Re: Only one value from a msSQL field. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-100749@lists.php.net to get a copy of this message | ||
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