Navigating through Records/Creating navigation. Please help!

brianb

Hello,

I'm looking for some code examples on how to do the following...

Say my MySQL database table has 110 entries in it. What I want to do is create a navigation scheme that looks like the following, only displaying 10 entries per page:

Now viewing PAGE 1 of 11
<<Previous 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 - 11 Next>>

Make sense?

Can anyone give me some code examples on how to create this sort of pagelist? Also, if the number of records grows or shrinks, the pagelist would be updated with the proper number of pages etc.

Any/All help is greatly appreciated!

Thanks.

pjleonhardt

search the coding and code critique forums for pagination

Hoangsta

hey, did u ever find any working example of pagination. i'm working on one and it's not doing so great.

brianb

Foudn a great example here:
http://lists.evolt.org/archive/Week-of-Mon-20020603/114032.html

Working perfectly for me! Hope it helps!

Hoangsta

thanks for the link. i read it....but i have a good link for u to look at too.

http://www.devshed.com/Server_Side/PHP/Paginating/page1.html