next 10 prev 10

[Anon]

I was wondering how to make a link thing that you see on every search page. Or a better example would be on a big guestbook.

<Prev> 1 2 3 4 5 6 7 8 9 10 <next>

I have a section of a site that constantly gets added to and it shows up on the page. Right now there are 20 or so entries on one page. I want it so that older entries keep getting pushed back so the newest 10 are always on page 1 and the oldest go back forever. Does anyone have an idea?

[Anon]

The trick to this is to get the information from a database i.e. MySQL. In MySQL the key is the LIMIT command, in other relational databases you would use the MINUS. There's an article in this site that can teach you step-by-step on how to do such, but be warned it's a bit buggy so you need to modify the codes to suit you.

[ziah75]

Make a field which keeps track of "post-date" and use a SQL-query that sorts by it.

$sql = "SELECT * FROM tablename ORDER BY your_date_field desc";

Then I've used a code posted in an article here, which gives you what you want (prev 1 2 3 next and so on), with selectable no_of_entries_per_page-variable.
Check this out:
http://www.phpbuilder.com/columns/rod20001214.php3?page=3

You will have to "integrate" that query in the above code, but that is not so complicated...

Hope this helps. =)

/Anders