SELECT COUNT

Using PHP and MySQL: Select COUNT with GROUP BY