Counting Duplicate Items

Shit4Brains

im having a bit of a problem. i have a script which records all visiters IP & Hostname. and im building a script to show all the results.

I want to show a list of IPs and how many times they appear in the database.

$db = mysql_connect("$host", "$user", "$pass") or die("Error connecting to database");

mysql_select_db("mydb",$db);

   $result = mysql_query("SELECT DISTINCT user_ip FROM hit_count",$db);

$num = mysql_num_rows($result);

if ($myrow = mysql_fetch_array($result)) {

print("<div align=\"center\">
  <center>
  <table border=\"1\" cellpadding=\"2\" style=\"border-collapse: collapse\" bordercolor=\"#999999\" cellspacing=\"0\" width=\"100%\">
<tr>
      <td width=\"10%\" bgcolor=\"#C0C0C0\">
      <p align=\"center\"><p align=\"center\"><font size=\"1\"><b>ID:</b></td>
      <td width=\"20%\" bgcolor=\"#C0C0C0\"><p align=\"center\"><font size=\"1\"><b>IP Address:</b></td>
      <td width=\"35%\" bgcolor=\"#C0C0C0\"><p align=\"center\"><font size=\"1\"><b>Hostname:</b></td>
      <td width=\"35%\" bgcolor=\"#C0C0C0\"><p align=\"center\"><font size=\"1\"><b>Access Time:</b></td>
    </tr>");

  do {

$ip = $myrow["user_ip"];

print("<tr>
      <td width=\"10%\">
      <p align=\"center\"><font size=\"1\">$id</td>
      <td width=\"20%\"><p align=\"center\"><font size=\"1\">$ip</td>
      <td width=\"35%\"><p align=\"center\"><font size=\"1\">$num</td>
      <td width=\"35%\"><p align=\"center\"><font size=\"1\">$access_time</td>
    </tr>");

 } while ($myrow = mysql_fetch_array($result));

print("</table>
  </center>
</div>");

$from = ($from + 9);
$prev = ($from - 16);

print("<p align=\"center\"><a href=\"?from=$from\">Next 9</a> | <a href=\"?from=$prev\">Previous 9</a></p>");

}

this is what i have but it doesnt quite work!

drew010

To start, dont use a do...while() loop for printing out the values.

Change
do {

$ip = $myrow["user_ip"];

print("<tr>
<td width=\"10%\">
$id</td>
<td width=\"20%\">$ip</td>
<td width=\"35%\">$num</td>
<td width=\"35%\">$access_time</td>
</tr>");

} while ($myrow = mysql_fetch_array($result));

to...
while($myrow = mysql_fetch_array($result)) {
$ip = $myrow['user_ip'];
...
and instead of referencing your variables as $id, $num, and $access_time, they are results of the mysql_fetch_array function so they must be treated as so, and referenced like $myrow['id']; and $myrow['num'];