| Rogue Rabbit 2004-11-25, 3:56 am |
| This is untested in this form but should work :)
It does not do a next/previous link
//use $_get to get start value
//pagelen is number of results per page
$pagelen = 30;
//start is start number e.g. 0,30,60,90 etc
$start = 0;
$query = "SELECT * FROM table LIMIT " . $start . ", " . $pagelen;
/* page numbers */
$pagelist = "<p>Page ";
$pagetot = ceil($num_rows / $pagelen);
for($pagenum = 1; $pagenum <= $pagetot; $pagenum++) {
if($start == ($pagenum - 1) * $pagelen){
//put page number in without link if it is this page
$pagelist .= $pagenum . " ";
}
else{
//put page number in with link if its not this page
$pagelist .= "<a href=\"filename.php?start=" . ($pagenum - 1) *
$pagelen . "\">" . $pagenum . "</a> ";
}
}
$pagelist .= "</p>\n";
//then where you want the list put
print $pagelist;
ABC123 wrote:
> Does anyone have a good tutorial or example code for doing results
> per page in PHP with MSSQL?
|