显示将多少行分组到同一字段中

Question

The query below shows a list of all "zip"s in a MySQL table. It groups rows that have the same "zip".

How could I create a new variable that shows how many rows share each "zip"?

$query2 = "select zip from submission
GROUP BY zip    
order by zip asc";  

Answer 1

Add COUNT(*) to your select list:

SELECT zip, COUNT(*) FROM submission GROUP BY zip ORDER BY zip ASC