When I select * from the table it always takes forever to load, so I set my site up to display 50 items per page. I can search through items 50 at a time forwards or backwards with no problem.

But, now lets say I want to be able to skip the first 500 entries (10 pages). How do I set up dynamic pages so I can go straight to page 10 instead of having to press the "next" link 10 times? Thanks for any help.

Like at the bottom of page one I want to have little page number links

2 3 4 5... etc.

That way when I'm on page 1, I can skip to page 5.... ya know like bulletin boards do.

Would I just make each link a select statement? How could I do that dynamically so I don't have to add another 10 pages after another 500 entries? Am I making any sense (because sometimes I feel like I talk incircles)? Thanks for any help.