Pagination with counted entries

[NetRoam]

Hey all!

I have a statistics-module where I store all sorts of information about every user-visit I have on my website - I have now listed out a complete list of IP-addresses and how many times that particular IP has visited my site like this:

IP 1 ... 78 visits
IP 2 ... 45 visits
IP 3 ... 32 visits
IP 4 ... 3 visits

and so on and so forth

All in all I have about 150-200 different IP's in the database which makes it a pretty long result-page, so of course I'd like to have a bit of pagination made with Previous - Next links and only 20 records per page ... Question is: How do I write my SQL-query so it will count all those 150-200 different IP's the database contains so I can get those 8-10 pages of results?

As long as I have that found out - the rest of a piece of cake!

I hope it's possible to figure out! Thanx in advance!!

/// NetRoam

[bubblenut]

http://www.phpbuilder.com/columns/rod20000221.php3

HTH
Bubble

[NetRoam]

For some reason I can't figure out how to use that one!!

What I used before I asked was the following:

if(!isset($_GET['pages']))
{
  $pages = 1;
}
else
{
  $pages = $_GET['pages'];
}

$max_results = 20;
$from = (($pages * $max_results) - $max_results);

$sql = "SELECT ip, count(*) AS hits FROM `simplecount` GROUP BY ip ORDER BY `hits` desc, ip asc LIMIT $from, $max_results";

$result = mysql_query($sql);

while ($row = mysql_fetch_array($result))
{
  echo ".... all the output!!";
}

The next thing I want to do is the pagination where I use this:

// Figure out the total number of results in DB:
$total_results = mysql_result(mysql_query("[SIZE=3][B]SELECT ip, COUNT(*) as num FROM simplecount GROUP BY ip[/B][/SIZE]"),0);

// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);

// Build Page Number Hyperlinks
// Build Previous Link
if($pages > 1)
{
  $prev = ($pages - 1);
  echo "<a href=\"".$_SERVER['PHP_SELF']."?stats=per_ips&pages=$prev\"><b>&laquo;</b></a> &nbsp;";
}

for($i = 1; $i <= $total_pages; $i++)
{
  if(($pages) == $i)
  {
    echo "$i &nbsp;";
  }
  else
  {
    echo "<a href=\"".$_SERVER['PHP_SELF']."?stats=per_ips&pages=$i\">$i</a> &nbsp;";
  }
}

// Build Next Link
if($pages < $total_pages)
{
  $next = ($pages + 1);
  echo "<a href=\"".$_SERVER['PHP_SELF']."?stats=per_ips&pages=$next\"><b>&raquo;</b></a>";
}

It's the SQL-query in the last code which is in bold I have problems with ... it outputs an IP-address starting with 129...* and since the rest of the code uses the 129 to figure out how many pages it needs - it gives me 7 pages whereas the output should have given me 11 ... Any ideas??