Mysql query simplification feature

Hello everyone! Faced such a problem
I need to count the number of rows by page column.
task:

id|page   
1 |zlit
2 |rus
3 |rus
4 |rus
5 |zlit

result:

total|page   
2    |zlit
3    |rus

The request is like this

$result = mysql_query("SELECT COUNT(page) FROM tab WHERE page='zlit' ");
$myrow = mysql_fetch_array($result);
$total=$myrow[0];

Do I have to make a request for each page or can I simplify it somehow?
Thanks in advance!


Answer 1, authority 100%

You can do this:

SELECT `page`, COUNT(*) as `total` FROM `tab` GROUP BY `page`