Help With Displaying Results

[JSHINER]

I have a database with information in it... 00001, 00002, 00002, 00003, etc.

 

I currently display it as:

 

foreach ($page['zips'] as $z) {

echo '<li>', $z['zips'] , $z['date_and_time'],'</li>';

}

 

How can I make it so IF there are two of the same zip it would print "00002 (3)"... the 3 meaning there are 3 entries containing that zip code.

 

and IF only one - just display 00001.

 

 

[skali]

query = 'select count(your_information_field) from your_table group by zips';

 

this query will give you count of the field you are trying to count group by zip code.

[boo_lolly]

something like this:

<?php
        $sql = "SELECT * FROM your_table ORDER BY zips";
        $query = mysql_query($sql);

        $i = 0;
        $current_zip = ""
        echo "<ul>\n";
        while($row = mysql_fetch_array($query)){
                if($current_zip != $row['zips']){
                        echo "<li>". $current_zip ." (". $i .")</li>\n";
                        $current_zip = $row['zips'];
                        $i = 0;
                }else{
                        $current_zip = $row['zips'];
                        $i++;
        }
        echo "</ul>\n";
?>

[boo_lolly]

sorry, forgot to add another conditional statement... this should work properly.

<?php
        $sql = "SELECT * FROM your_table ORDER BY zips";
        $query = mysql_query($sql);

        $i = 0;
        $current_zip = ""
        echo "<ul>\n";
        while($row = mysql_fetch_array($query)){
                if($current_zip != $row['zips']){
                        if($current_zip != ""){
                                echo "<li>". $current_zip ." (". $i .")</li>\n";
                                $current_zip = $row['zips'];
                                $i = 0;
                        }
                }else{
                        $current_zip = $row['zips'];
                        $i++;
        }
        echo "</ul>\n";
?>