Jump to content


Photo

navigation <PREV> ****** <NEXT>. next not working to well???


  • Please log in to reply
2 replies to this topic

#1 spires

spires
  • Members
  • PipPipPip
  • Advanced Member
  • 492 posts

Posted 11 July 2006 - 03:14 PM

Hi

I am creating a guestbook, that only displays 5 entries at once.
to view the rest i have navigation at the bottom.
<PREV> 123456789 <NEXT> ect

the <PREV> and 123456789 work but i cant get the <NEXT to work>
At the moment it only displays on page 1.

Here is my code, can anyone see anything wrong with this?
<?php
$limit=5; 
$numresults=mysql_query("SELECT date, title FROM $db_tbl") or die("query 1 failed");
$numrows=mysql_num_rows($numresults);


if (empty($offset)) {
    $offset=0;
}

$query = "SELECT * FROM $db_tbl ORDER by ID DESC limit $offset,$limit";
$result = mysql_query($query)
or die ("query 2 failed");
?>


<?php
// next
if (!($offset/$limit) == $pages && $pages!=1) {

    $newoffset = $offset+$limit;
    print "<a href=\"$PHP_SELF?offset=$newoffset\">NEXT</a><p>\n";
}

?>


Thanks for your help
How to make over $600 a day from AdSense? Discover EXACTLY how he does it in these videos:
http://www.adsense-online.com

#2 micah1701

micah1701
  • Members
  • PipPipPip
  • Advanced Member
  • 613 posts
  • LocationEllington, CT USA

Posted 11 July 2006 - 03:22 PM

just a thought, do you have globals turned on/off?

when you use the url: $PHP_SELF?offset=$newoffset
your script may not be receiving the offset variable.

you many need to use $_GET['offset'] instead of just $offset
"Confidence in the face of risk."

#3 spires

spires
  • Members
  • PipPipPip
  • Advanced Member
  • 492 posts

Posted 11 July 2006 - 03:24 PM

Hi thanks for the reply.

Do you mean

<?php
// next
if (!($offset/$limit) == $pages && $pages!=1) {

    $newoffset = $offset+$limit;
    print "<a href=\"$_GET['offset']?offset=$newoffset\">NEXT</a><p>\n";
}

?>
How to make over $600 a day from AdSense? Discover EXACTLY how he does it in these videos:
http://www.adsense-online.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users