Determining Top # from MySQL
| From: | Ashley M. Kirchner | Date: | Sun, 11 Apr 2010 02:02:27 +0000 |
| Subject: | Determining Top # from MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-303977@lists.php.net to get a copy of this message | ||
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?