Next/Previous script problem

chrima

Hi guys,
I'm currently creating a Next/Previous script (with page number breadcrumbs) for my catalogue.
I've just about completed it except for one problem.
Lets say i pass the $genre variable to the script. This value is then queried and the results shown.
Lets say 21 results were found...the value for $totalrows.
This all works fine but the "Skip to Page" part of the script doesn't display the end page number...for example, 21 row results only displays page number 1 and 2 but not the 3rd (which it should because i limit the results to 10 items per page).
Likewise, if i had 14 results the "Skip to Page" part of the script only displays the number 1 and not the number 2 for the next page.
Any ideas on how to rectify this little problem?
I've been fiddling around for hours but to no avail.

I've posted the bulk of the script below:

<?
$genre = $_GET['genre'];
$page = $_GET['page'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Group</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<META http-equiv=imagetoolbar content=no>
<LINK href="styles.css" type=text/css rel=STYLESHEET>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="630" border="0" cellspacing="10" cellpadding="0">
  <tr> 
    <td> 
<?
include ("include/dbconnect.php");							  

$limit = 10; 
$query_count = " SELECT * FROM movie_genre WHERE genre_id=$genre"; 
$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);

$query = "SELECT * FROM movie, movie_genre, movie_status 
WHERE movie.movie_id=movie_genre.movie_id AND movie.movie_id=movie_status.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 width=100% border=0>
        <TR> 
          <TD noWrap width=11 height=0></TD>
        </TR>
        <TR> 
          <TD></TD>
          <TD> <TABLE cellSpacing=0 cellPadding=0 width=100% border=0>
              <TR> 
                <TD class=bgdrkgrey colSpan=6 height=1></TD>
                <hr width="100%" noshade>
              <TR> 
                <TD colSpan=6 height=5></TD>
              </TR>
              <TR> 
                <TD class=btextwhitebg noWrap>
                Skip to Page&nbsp;&nbsp; 
<?
if($page != 1)
$pageprev = $page - 1; 

$numofpages = $totalrows / $limit; 
for($i = 1; $i <= $numofpages; $i++){ 
if($i == $page) 
echo "$i&nbsp;"; //active
else 
echo("<a href=\"genre.php?genre=$genre&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.php?genre=$genre&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.php?genre=$genre&page=$pageprev\">Previous</a>&nbsp;"); 
}else

echo("&nbsp;"); 
?>
                  <? 
echo("<a href=\"genre.php?genre=$genre&page=$pagenext\">Next</a>"); 
}else if($totalpagerows != $limit){
echo("&nbsp; </TD><TD class=btextwhitebg align=right><a href=\"genre.php?genre=$genre&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>
      </TABLE>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td background="images/thin_grey_line.gif"><img src="images/spacer_1.gif" width="10" height="10"></td>
        </tr>
      </table>

DISPLAY ROW RESULTS HERE 

</td>
  </tr>
</table>
</body>
</html>

Cheers,
micmac

clandestine555

nevermind me, i just wrote it down on notepad and worked it out how you're doing it logically, although the way i did it was with a $high and $low value instead still reading your code tho

planetsim

First Read My Sig it says search

click on it. There are been that many discussions about Next/Prev scripts and pagination that i think you should find many examples.

But the basics behind these scripts are

First

Create a query with the limit
Create a second query exactly the same minus the limit statement.

Count the totalrows
Check if the start or page not 0 and show Prev Link

If Total rows greater than start show Next

Than basically have a high and low statement to create the 1 2 3 4 link bit.

I have got one, but its not fully tested to be shown as a good example.