Next and Previous Buttons

leebo

I have manged to get results from a database using "next" & "previous" buttons but say 20 records are shown - when i click the "next" button theres no more records to show ! and goes to a blank page.

So i need not to display the next button after the last record is shown - can anyone help me with this problem ?

The code i`m using is this:

$prevlimit=$limit-5;

if ($prevlimit<0) $prevlimit=0;
if ($limit > 4 )

echo "<a href=\"$_SERVER[PHP_SELF]?search=$search&limit=$prevlimit>previous 5</a>";
else
echo " ";
$nextlimit=$limit+5;
if ($limit < $no_of_records ) <------ (This is the problem line !)

echo "<a href=\"$_SERVER[PHP_SELF]?search=$search&limit=$nextlimit\">next 5</a>";

else
echo " ";
?>

Thanks

Lee

Traduim

I think we're missing something.

If you have 245 records, last page will start by $limit = 240?

If the answer is yes,

f ($limit < $no_of_records ) will be true even if you are in the last page.

I think you should set $nextlimit after displaying current pages results, and then ask if ($nextlimit < $no_of_records).

jmcneese

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10206378