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
[EMAIL PROTECTED]

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to