Spreading results over multiple pages?

[Jamier101]

I've finally got all of my page designs finished and its only just occurred to me that if I run a large search then the results are going to flood onto the page, is it possible to make the database either return a user selected amount of result or if all are to be returned then have them over multiple pages where the user could click next and previous?

[Matthew1980]

Hi there Jamier101,

This my boy is called Pagination, there are Loads of free scripts out there that can be quickly added to your project, just do a google search for "php/mysql pagination" and this will get you going in the right direction, I think as it was Eelixduppy who wrote a nifty tutorial for this a while back, check this link out [webmasterworld.com] And much Kudos to Eelixdupy for writing this, as I am sure it has helped many people over the last few years!

I hope that is what you were referring to anyway!

Cheers,
MRb