section31 — Fri, 20 Jun 2003 18:03:07 +0000

Ah ok... I'll try that.

thanks

druagord — Fri, 20 Jun 2003 17:57:50 +0000

by using the select Found_rows() you will have the total numbers of row you divid it by 100 round up and you get how many link you need to put. then on link 2 put min limit 100 on link 3 put min limit 200 etc...

section31 — Fri, 20 Jun 2003 17:53:53 +0000

Yeah I knew about the LIMIT option but the # of rows is dynamic so how would I get it to have like page numbers in the bottom to print a certain number of rows when clicked.

druagord — Fri, 20 Jun 2003 17:49:13 +0000

for the request the SQL should look like this on the firstpage

<?php
\"SELECT address,datetime, referer FROM stats where id='1' LIMIT 0,100\";
?>

this will limit the response from the server to the first 100 rows to get the

<?php
\"SELECT address,datetime, referer FROM stats where id='1' LIMIT 100,100\";
?>

this will give you rows from 100 to 200
here is the sytax for limit

LIMIT startrecord, numrecord

if you have mySQL 4 or greater use this to get the total number of record and then you can display your links based on that

<?php
\"SELECT SQL_CALC_FOUND_ROWS address,datetime, referer FROM stats where id='1' LIMIT 0,100\";
\"Select FOUND_ROWS()\";
?>