MySQL COUNT function

Using PHP and MySQL: Select COUNT with GROUP BY