Re: Getting one of each result from MySQL
| From: | Jason N. Perkins | Date: | Fri, 13 Apr 2001 05:57:53 +0000 |
| Subject: | Re: Getting one of each result from MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-48412@lists.php.net to get a copy of this message | ||
> The thing is, I want to have only one entry for each guild, and I want
them
> to be in alphabetical order.
try the following sql:
"select distinct guild from tablename order by guild"
--
:: jason n. perkins
:: email -> jason[at]somebodydial911.com
:: url -> www.somebodydial911.com
:: "for a vegetarian rents, you're a (obscene gerund, expletive) evil shot."