Re: Determining Top # from MySQL
| From: | Dan Joseph | Date: | Sun, 11 Apr 2010 02:37:08 +0000 |
| Subject: | Re: Determining Top # from MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-303979@lists.php.net to get a copy of this message | ||
Eh, he's off topic, but we've talked plenty SQL on here before...
SELECT num, COUNT( num ) FROM table GROUP BY num;
I don't have a myqsl server to test that, but should do it.
--
-Dan Joseph
www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month. Promo
Code "NEWTHINGS" for 10% off initial order
http://www.facebook.com/canishosting
http://www.facebook.com/originalpoetry