Creating a 'Previous entries' link

[ali_p]

Hi,

I have created a simply news database that lists news items by the latest date first. Due to the page design I can only show the latest 10 entries in the database. I need to put a link that will say 'previous entries' (possibly limited to 10 also) that will list the previous older entries.
Does anyone know of or can direct me to a script that will do this please.

[CoderDan]

you need your link to pass a variable to indicate you want 'previous' and if that variable is set, modify the query that selects the news from the table to modify the limit clause from LIMIT 10 to LIMIT 10, 10 or similar.

[ali_p]

Yes. I know this is what I need to do, but I need some help in doing it. Is there a script or code that can explain how this is done. I can find pagination examples but I think this needs to work slightly differently.

Thanks

[CoderDan]

at it's most basic something like this:

<?php
$entries_to_show = 10;
if ( $_GET['more'] )
{
	$start = $entries_to_show;
}
else
{
	$start = 0;
}
$query  = "SELECT * FROM table WHERE whatever ";
$query .= "LIMIT ".intval( $start ).", $entries_to_show ";
$query .= "ORDER BY whatever ";
?>

[ali_p]

ok thank you for this. I'm a bit confused still, what does .interval do ? Also i'm ordering by date the last 10 entries first so then the previous link needs to display the next 10 ordered by date and so on. Then I will need to have a 'more recent' link on the previous pages to get back to the latest items. Wordpress have it perfectly so basically i'm trying to copy this. I will attempt a tweek of a pagination code that i have used and post here if successful.

Thanks again

[Weedpacket]

[man]intval[/man]