hi,I am trying to do page navigation system. let say i have 13 records and per page i wan to display 10. So there will be 2 pages. i want to display them this way
page1
Displaying :1-10 of 13 records page 1 pages:1 2)
page2
Displaying :11-13 of records page 2 pages:12
but my code is displaying starting from 0-10 in first page ,11-12
in second page. So it counting 0 as well. what i can so it start from 1.(ie.1-10,11-13)
my code
function makepagelink($link, $page, $pages) {
$page_link = "<b>[";
if($page!=1) $page_link .= " <a href=\"$link&page=1\">«</a> <a href=\"$link&page=".($page-1)."\">‹</a>";
if($page>=6) $page_link .= " <a href=\"$link&page=".($page-5)."\">...</a>";
if($page+4>=$pages) $pagex=$pages;
else $pagex=$page+4;
for($i=$page-4 ; $i<=$pagex ; $i++) {
if($i<=0) $i=1;
if($i==$page) $page_link .= " $i";
else $page_link .= " <a href=\"$link&page=$i\">$i</a>";
}
if(($pages-$page)>=5) $page_link .= " <a href=\"$link&page=".($page+5)."\">...</a>";
if($page!=$pages) $page_link .= " <a href=\"$link&page=".($page+1)."\">›</a> <a href=\"$link&page=".$pages."\">»</a>";
$page_link .= " ]</b>";
return $page_link;
}
// End of function
$resultc=mysql_query("select listid,cid,listname,description from yp_list where cid=$cid", $dbi);
$num_record = mysql_num_rows($resultc);
if(isset($_GET['page']))
$page=intval($_GET['page']);
else $page=1;
$currentpage=$page;
$display = 10;
$startrecord=($display*($page-1));
#$startrecord=$startrecord+1;
$pages=ceil($num_record/$display);
if($currentpage == $pages) {
$lastrecord = $num_record;
}
else {
$lastrecord = ($currentpage * $display);
}
if($pages>1)
$page_link = makepagelink("modules.php?name=Yellow_Pages&file=viewdir&cid=$cid", $page, $pages);
else
$page_link = "";
$result=mysql_query("select listid,cid,listname,description,state,country,website from yp_list where cid=$cid limit $startrecord,$display", $dbi);
echo"$startrecord-$lastrecord of $num_record record(s) » Page $currentpage ----$page_link ";
