Reading the number of duplicate zip codes in a database

[Peggy]

I have a small table in a database I want to count the number of duplicate entries of zip codes and then display the zip code with the number of times it appears in the database. Eventually I will want to group these zip codes according to the year they were entered. I can figure out the year thing but I am really struggling counting the zips.

Here is my code:

 

$sql ='SELECT COUNT(*) AS cnt  FROM zip  GROUP BY visitor_zip ORDER BY time_register';

$result = mysql_query($sql,$db) or die(mysql_error(). "<br />SQL: $sql");

$row = mysql_fetch_array($result);

     

      print '<ul>';

 

  do{

        print '<li>' . $row['visitor_zip'] .'  '. print $row['cnt'] . '</li>';

  }while($row = mysql_fetch_array($result))

 

  print '</ul>';

 

---------------------------------------------------------------

this result of this code reads something like this:

 

                          3  1

                          1  1

                          3  1

[gassaz]

SELECT visitor_zip, COUNT(visitor_zip) AS cnt  FROM zip  GROUP BY visitor_zip ORDER BY time_register