Pagination help

pagination

[chrissim]

hi,

How do you fix the below pagination to show first 5 or 10 pages? something like previous 1,2,3,4,5 next. The pagination at the moment is showing all pages and it was kind of messy.

$count_result = mysql_query("SELECT COUNT(*) FROM $table");
$count_row = mysql_fetch_array($count_result);
//fetch the total number of rows in the table
$count = $count_row["COUNT(*)"];
//we will use this information to build our navigation list

echo (($page>1)?"<a href='".build_url("sql.php", "page", $page-1)."'><font size='2px'>previous</font></a>":"previous")." | ";
for($i=1; $i<=($count/$records_per_page)+1; $i++){
 if($i!=$page)
  echo "<a href='".build_url("sql.php", "page", $i)."'>$i</a>";
 else
  echo $i;
 //output a little symbol (|) to seperate the links
 //but not for the last link
 if($i<$count/$records_per_page)
  echo " | ";
}
echo " | ".(($page<$count/$records_per_page)?"<a href='".build_url("sql.php", "page", $page+1)."'><font size='2px'>next page</font></a>":"next");

[Matthew1980]

Hi there chrissim,

Whether this is relevant or not, I think you would benefit from reading this, Eelixduppy posted this years ago (and much kudos to him for it :)), and it helped me to understand the mechanics on pagination, and rather than re post whats been said & discussed, read this and all will become clear.

Enjoy: [webmasterworld.com ]


Cheers,
MRb

[enigma1]

You need to modify your for loop so the page numbers displayed are subject to the page viewed.

$total_pages = ceil($count/$records_per_page);
$cur = (int)($page / $count);
for($i=1+(($cur-1)*$count); ($i<$cur*count) && $i<=$total_pages; $i++){

And you likely need to expand the mysql query to take into account not just tables, see how the oscommerce does it, where this code sample is based on.

[chrissim]

Thanks guy i give it a try here :)