Next/Prev Problem

[DigitalExpl0it]

Im having a little problem trying to make a Next button for my records.

so far im doing this

<?
if ($offset == "" and $onset == "") {
$offset = "10";
$onset = "0";
}
$offset2 = ($offset + 11);
$onset2 = ($offset2 - 11);

$sql = "select * from wml WHERE wml_cat='Themes' ORDER BY wml_id ASC LIMIT $onset,$offset";

if ($text == "") {
echo "<p>No more Data</p><p><a href='http://www.rbcode.com/wml'>Home</a></p>";
} else {
?>
<A HREF="themes.wml?onset=<? echo "$onset2"; ?>&offset=<? echo "$offset2"; ?>">Next</A>&nbsp;&nbsp;<A href='http://www.rbcode.com/wml'>Home</A>
<?
}
?>

now this works great on 3 of my scripts, but this isnt working write on one of them. what happends is when the Next link gets to 10-21

$onset = 10
$offset = 21

it will post all 21 records, not records 10-21

and ideas?

[planetsim]

Im not going to write code for you. But try and take a look at the tutorial at http://spoono.com and try to intergrate yours into the same concept..

really you need 2queries which you do not have.. it maybe why its not working

[DigitalExpl0it]

humm well i llcheck it out, I was thinking about just rewriting it the hard way 🙂

[DigitalExpl0it]

humm wierd all I did was this after looking at the following turtorial and it works fine

$sql = "select * from wml WHERE wml_cat='Themes' ORDER BY wml_id ASC LIMIT $onset,11";