Next/Previous script problem

[micmac]

Hi all,
I currently have a next/previous script that works just fine but i want to make a slight modification. I've tried several times to tweek it but to no avail.
At the moment, if $totalrows equals lets say 523 the page results equal 53. There are too many page links displayed across the screen.
Can anyone tell me how to get it to display the first 20 page links if the $totalrows >= 201 (or if $numofpages >= 20)?
The remaining results will display in multiples of ten
eg.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 30 40 50

If the user clicks on 20 the page results will look like

1 2 3 4 5 6 7 8 9 10 20 21 22 23 24 25 26 27 28 29 30 40 50

If the user clicked on the 40 then the page results would look like

1 2 3 4 5 6 7 8 9 10 20 30 40 41 42 43 44 45 46 47 48 49 50

I hope that makes sense.
Any ideas on how to achieve this?

Here is the code:

<?
$limit = 10; 
$query_count = " SELECT * FROM movie_genre WHERE genre_id='$list_id'"; 
$result_count = mysql_query($query_count); 
$totalrows = mysql_num_rows($result_count);
while  ($row1 = mysql_fetch_array($result_count)) { 
$new_genre_id = $row1["genre_id"];
}
if(empty($page)) 
$page = 1; 
$limitvalue = $page * $limit - ($limit);
if($sortby == 'top_sellers'){ 
$query = "SELECT * FROM movie, orders WHERE movie.movie_id=orders.movie_id 
ORDER BY movie.movie_title LIMIT $limitvalue, $limit";
} else if($sortby == 'member_ratings'){
$query = "SELECT * FROM movie, movie_genre WHERE movie.movie_id=movie_genre.movie_id 
AND movie_genre.genre_id='$new_genre_id' ORDER BY member_ratings LIMIT $limitvalue, $limit"; 
} else if($sortby == 'title'){
$query = "SELECT * FROM movie, movie_genre WHERE movie.movie_id=movie_genre.movie_id 
AND movie_genre.genre_id='$new_genre_id' ORDER BY movie_title LIMIT $limitvalue, $limit"; 
} else if($sortby == 'actor'){
$query = "SELECT * FROM movie, movie_genre WHERE movie.movie_id=movie_genre.movie_id 
AND movie_genre.genre_id='$new_genre_id' ORDER BY last_name LIMIT $limitvalue, $limit"; 
} else {
$query = "SELECT * FROM movie, movie_genre WHERE movie.movie_id=movie_genre.movie_id 
AND movie_genre.genre_id='$new_genre_id' ORDER BY movie_title DESC LIMIT $limitvalue, $limit"; 
}
$result = mysql_query($query) or die("Error: " . mysql_error());
$totalpagerows = mysql_num_rows($result); 
?>
<TABLE cellSpacing=0 cellPadding=0 border=0>
  <TR> 
    <TD width=10 colSpan=3 height=15><SPACER height="15" width="10" type="block"></TD>
  </TR>
</TABLE>
<table width="580" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td><hr width="100%" size="1"></td>
  </tr>
  <tr>
    <td valign="top">
<TABLE width="100%" border=0 cellPadding=0 cellSpacing=0>
  <TR> 
    <TD class=btextwhitebg noWrap>Skip to Page&nbsp;&nbsp; 
<?
if($page != 1)
$pageprev = $page - 1; 

$numofpages = ceil($totalrows / $limit); 
for($i = 1; $i <= $numofpages; $i++){ 
if($i == $page) 
echo "$i&nbsp;"; //active
else 
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$i\">$i</a>&nbsp;"); //non active
} 
if($numofpages != 1){ 
if($i == $page) 
echo "$i"; //active
}else if($totalpagerows != $limit){
//echo("$i"); //active
}else 
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$i\">$i</a>"); //non active 
if(($totalrows - ($limit * $page)) > 0){ 
$pagenext = $page + 1;
?>
                                    &nbsp;</TD>
                                  <TD class=btextwhitebg align=right> 
                                    <?
if($page != 1){
$pageprev = $page - 1;
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$pageprev\">Previous</a>&nbsp;"); 
}else

echo("&nbsp;"); 
?>
                                    <? 
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$pagenext\">Next</a>"); 
}else if($totalpagerows != $limit){
if(!$_GET['page']){
} else {
echo("&nbsp; </TD><TD class=btextwhitebg align=right><a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$pageprev\">Previous</a>"); 
}
}
?>
                                  </TD>
                                </TR>
                                <TR> 
                                  <TD height=3></TD>
                                </TR>
                                <TR> 
                                  <TD class=btextwhitebg width=200>Items 
                                    <? echo ($page * $limit) - ($limit - 1) ?>
                                    - 
                                    <? echo ($page * $limit) + ($totalpagerows - $limit) ?>
                                    of 
                                    <? echo $totalrows ?>
                                    Results</TD>
                                <tr> 
                                  <td colspan="2"></td>
                                </TR>
                                <TR></TR>
                              </TABLE></td>
                          </tr>
                          <tr>
                            <td><hr width="100%" size="1"></td>
                          </tr>
                        </table>

Cheers,
micmac

[iceraider]

$var = floor(($page/10)-1);
$var2 = floor(($totalrows - 20)/10);

for($i = 1; $i <= $numofpages; $i++){
 if($i >= 20) {
    if($var == $i) {
    	for ($a = 1; $a <= (($numofpages - 20) - $var * 10); $a++) {
		  //PRINT THE 10
	     }
	} else {
	   // PRINT THE MULTIPLE OF 10
	}
 } else {
    // PRINT SINGLE NUMBERS BELOW 20
 }
}

This small thing takes alot of coding

Tell me if that gives you an idea.

Edit: That would have to go in your for loop.

[micmac]

Hi icereaider, thankyou for your reply.
I think you are on the right track, however i am having trouble with the "print" of 10 and the "print" of multiple 10.
Are you able to take another look and tell me where i might be going wrong or what i need to add to the script?

Here's the code so far:

<?
if($page != 1)
$pageprev = $page - 1; 

$numofpages = ceil($totalrows / $limit); 

$var = floor(($page/10)-1); 
$var2 = floor(($totalrows - 20)/10);

for($i = 1; $i <= $numofpages; $i++){ 
 if($i >= 20) { 
    if($var == $i) { 
        for ($a = 1; $a <= (($numofpages - 20) - $var * 10); $a++) { 
          //PRINT THE 10

     } 
} else { 
   // PRINT THE MULTIPLE OF 10 

} 
 } else { 
    // PRINT SINGLE NUMBERS BELOW 20
	if($i == $page) {
echo "$i&nbsp;"; //active
} else {
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$i\">$i</a>&nbsp;"); //non active
} 
 } 
}

if($numofpages != 1){ 
if($i == $page) 
echo "$i"; //active
}else if($totalpagerows != $limit){
//echo("$i"); //active
}else 
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$i\">$i</a>"); //non active 
if(($totalrows - ($limit * $page)) > 0){ 
$pagenext = $page + 1;
?>
&nbsp;</TD>
                                  <TD class=btextwhitebg align=right>
                                    <?
if($page != 1){
$pageprev = $page - 1;
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$pageprev\">Previous</a>&nbsp;"); 
}else

echo("&nbsp;"); 
?>
                                    <? 
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$pagenext\">Next</a>"); 
}else if($totalpagerows != $limit){
if(!$_GET['page']){
} else {
echo("&nbsp; </TD><TD class=btextwhitebg align=right><a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$pageprev\">Previous</a>"); 
}
}
?>

Regards,
micmac

[iceraider]

Just replace those two comments with

    if($i == $page) { 
echo "$i "; //active 
} else { 
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$i\">$i</a>&nbsp;"); //non active 
}

[micmac]

Hi iceraider,
I tried what you suggested but i continue to get the same results as before.
eg:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53

If you are on the first page then everything is a link except for number one.
If you have the time are there any more suggestion you can think of?

Cheers,
micmac

[iceraider]

Sorry I forgot this were I put the comment

// PRINT THE MULTIPLE OF 10

Thats where you print 30 40 50

so your going to have to floor it again.

[iceraider]

so replace

// PRINT THE MULTIPLE OF 10

with

$floor_i = floor(($i/10)).'0'; 
echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$floor_i\">$floor_i</a>&nbsp;"); //non active 

[micmac]

Hi iceraider,
Just about there 🙂
The only problem is that the results are displayed like:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 20 20 20 20 20 20 20 20 20 30 30 30 30 30 30 30 etc

I assume i need to group the results, just not sure how.

Cheers,
micmac

[micmac]

Would i need to take them out of the loop?

[iceraider]

We need to set $i like up 10 so it doesn't do that

Tell me where that gets you.

$floor_i = floor(($i/10)).'0';  

echo("<a href=\"genre_list.php?list_id=$list_id&sortby=$sortby&page=$floor_i\">$floor_i</a>&nbsp;"); //non active

if(($numofpages - $i) < 10) {
   $i = ($numofpages - $i) + $floor_i;
} else {
   $i += 10;
}

[micmac]

The page does not load now, it appears to be looping over and over.
Would it have something to do with the loop?

Thanks again,
micmac

[micmac]

Got it working iceraider.....thankyou greatly for all your assistance.

Cheers,
micmac