Re: Determining Top # from MySQL
| From: | Kevin Kinsey | Date: | Sun, 11 Apr 2010 02:22:09 +0000 |
| Subject: | Re: Determining Top # from MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-303978@lists.php.net to get a copy of this message | ||
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| +---+-----+Dunno, is this relevant? http://lists.mysql.com/mysql/25829 kdk| 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?