I need some assistance on selecting and counting records from a database.
Every record in the table will have a category example 'News' and 'Sport'. Let say News has 17 category's and sport has 11. How can I list all category's and count the total amount of records within that category.
so. . .