Provide Navigation of Records or Record Set
 

Hi Folks!


How are you doing? Well, I am stuck with something.

Let me state it here:

We are fetching rows from a given database/table. Let us say the number of rows is 100 or 1000, maybe.

We then display them on a webpage. As we scroll up and down, it looks really ugly or something undesired.

So, we display, let's say, 25 rows per page. We provide NEXT and PREVIOUS buttons or links at the bottom or top or on both the sides for an easy navigation of the records.

How do we achieve it? We are already using it on this web site also. We are not flooded with all the comments on a single page! ;)

So, how is that done?

Extra Notes:

Please note that I am using PHP. I should also specify that I am using MS-Access for this particular application that I am building.