<< Previous 1 2 3 Next >> ??

[Tim Mousel]

Hi,

Pulling data to display from a mysql database, how do I show the results over multiple pages with tags similar to:

<< Previous 1 2 3 Next >>

Thanks in advance,

Tim

[Freddie Bingham]

There are articles on www.phpbuilder.net that cover this topic. Also you can easily see how vBulletin does it in a few lines by looking at the code in showthread.php

Also note how the MySQL query uses LIMIT to restrict the correct amount of returns for each page.

[Tim Mousel]

Thanks freddie

[s.molinari]

Check out: http://www.phpbuilder.com/snippet/detail.php?type=snippet&id=21

you should get what you want there. Plus there are also some good articles about prev next links.

hope I could help.

[Vinay]

i've written one of these myself.. its located at:

http://www.geekarea.org/go.kryogen/articles/action=show/id=12