Re: Newman Says: Only one value from a msSQL field.
| From: | Leif K-Brooks | Date: | Sun, 02 Jun 2002 02:11:37 +0000 |
| Subject: | Re: Newman Says: Only one value from a msSQL field. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-100268@lists.php.net to get a copy of this message | ||
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 of each (not mating).
$sql = "SELECT * FROM brands WHERE 1 ORDER BY sId DESC LIMIT 6";
lists everything ..
ANy help would be cool.
Phil