[SOLVED] 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

 

 

[gevans]

try this;

 

$sql = "SELECT `visitor_zip` AS `zip`, COUNT(`visitor_zip`) AS `cnt`
FROM `zip`
GROUP BY `visitor_zip`";

$result = mysql_query($sql,$db) or die(mysql_error(). "<br />SQL: $sql");
print '<ul>';
while($row = mysql_fetch_array($result))
{
print '<li>' . $row['zip'] .'  '. print $row['cnt'] . '</li>';
}
print '</ul>';

[Peggy]

Thank You!!!! :D