Ashley M. Kirchner wrote:
Given a MySQL query like this $q = "select num from table", I get a result
like this:
+---+
|num|
+---+
| 1|
| 4|
| 6|
| 2|
| 4|
| 5|
| 3|
| 2|
| 4|
| 2|
| 3|
| 3|
| 2|
| 1|
+---+
What I want is a listing of numbers sorted by the amount of times they
appear (so I can take a top 5, or top 10):
+---+-----+
|num|count|
+---+-----+
| 2| 4|
| 3| 3|
| 4| 3|
| 1| 2|
| 5| 1|
| 6| 1|
+---+-----+
Is this a query that I can feed to MySQL, or is this something I need to
sort out in PHP?
Dunno, is this relevant? http://lists.mysql.com/mysql/25829
kdk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
