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

[spires]

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?
[code]
<?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");
?>
[/code]


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

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

?>
[/code]


Thanks for your help

[micah1701]

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

[spires]

Hi thanks for the reply.

Do you mean

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

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

?>