Re: Best way to sort?
| From: | John Nichel | Date: | Thu, 03 Jun 2004 13:46:55 +0000 |
| Subject: | Re: Best way to sort? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-187523@lists.php.net to get a copy of this message | ||
Brian Dunning wrote:
I'm not sure if this is a complex SQL query or a PHP array sorting thing, but what's the best way to take this data: Tom Greg Brian Tom Brian Tom And return the following results, sorted by number of records: Tom - 3 Brian - 2 Greg - 1 Any thoughts?MySQL's DISTINCT, in conjuction with COUNT -- John C. Nichel KegWorks.com 716.856.9675 john@kegworks.com