RE: [PHP] Newman Says: Only one value from a msSQL field.

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:

Re: [PHP] Newman Says: Only one value from a msSQL field.

I don't know about msSQL, but in mySQL you can do something like $sql = "SELECT * FROM brands WHERE 1 GROUP BY field ORDER BY `sId` DESC LIMIT 6"; 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

[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