limiting page number appearance

[Trojan]

Hey peeps,

i have a table with 10,000 rows. i have managed to display 20 records at a time with use of next and prev. I also have a page numbers that appear at the bottom so users can click directly onto a specific page. How do i do what phpbuilder has done and only display about 6 page numbers and then make them dissappear and appear when they are needed. cos i dont want 300 page number cluttering up the screen.

Location:
Posts: 3
for ($i=1; $i <= $pages; $i++){
$ppage = $limit*($i - 1);
if ($ppage == $page){

echo " $i "; }
else{

echo "<a href=\"$PHP_SELF?query=$query&page=$ppage&limit=$limit\"> $i </a>";}
}

this is the code used to display the page numbers

[mayus]

if ($page > 5) { $first _page = $page - 5; $last_page = $page+5; }
else { $first_page = 0; $last_page = 10; }

for ($i=$first_page;( ($i <= $page) && ($i < $last_page) ); $i++)
{
$ppage = $limit*($i - 1);
if ($ppage == $page) echo " $i ";
else
{
echo "<a href=\"$PHP_SELF? query=$query&page=$ppage&limit=$limit\"> $i </a>";
}
}

Thats a long shot piece of code 🙂 but should work...should display 5 before and 5 after current page or first 10 pages

Mayu

[Trojan]

Mayus,

thanx for that piece of code but now only one link page appears and thats 0. i'll try doin sumthin to make it come out right!!!

🙁

[Trojan]

nope any ideas

[mayus]

Well the only I can seen wrong with the code is on this line :

if ($page > 5) { $first _page = $page - 5; $last_page =

$page+5; }

and also :

for ($i=$first_page;( ($i <= $page) && ($i < $last_page) ); $i++)

should be :

for ($i=$first_page;( ($i <= $pages) && ($i <= $last_page) ); $i++)

the variable $first _page is supposed to be $first_page and I confused your variable $page with $pages.

apart from that the code looks ok?

hope that helps.

Mayu

[Trojan]

not to offend you Mayus as you have tried to help me , but it still dont work. heres the entire original code

if (!($limit)){
$limit = 20;}

if (!($page)){
$page = 0;}

$numresults = mysql_query($sql4, $connection) or die ("Could nt execute query");

$numrows = mysql_num_rows($sql_result4);

$pages = intval($numrows/$limit);

if ($numrows%$limit){
$pages++;}

$current = ($page/$limit) + 1;

if (($pages < 1 ) || ($pages == 0)){
$total = 1;}

else {
$total = $pages;}

$first = $page + 1;

if (!((($page + $limit)/ $limit) >= $pages) && $pages != 1){
$last = $page + $limit;}

else {
$last = $numrows;}

for ($i=1; $i <= $pages; $i++){
$ppage = $limit*($i - 1);

if ($ppage == $page){
echo " $i ";
}
else{
echo "<a href=\"$PHP_SELF?query=$query&page=$ppage&limit=$limit\"> $i </a>";}
}