How to create a next and previous functionality. I have a mysql table called Users then I have three columns
I want to if I’m in page Hello I would get all the sub_page column data. Then if I’m in column hello and sub_page column it would display all the texts in it. That may be easy but what I want to figure out is how the next and previous functionality would work. The picture representation explains it better. Thanks
Next and previous pages are typically implemented through the use of the “LIMIT” clause in MySQL. You fetch the results of all the pages and then using the LIMIT clause you can select which results are shown on the first page versus consecutive pages.
Assume you want to show 10 results per page. LIMIT 0,10 would show the first ten (page 1), LIMIT 10,10 would show the next ten (page 2) etc. See the pattern?
x = (Page Num - 1) * results_per_page
Then you use that in the LIMIT clause LIMIT x, results_per_page
So for your example you can query for the page that is hello with the sub_page thanks and from those results use LIMIT clause.
I hope you get what I am saying. 
Hi there, I have created pagination with the next and previous functionality. You will get a complete guide to integrate into your project step by step. So, you can get its source code through the following URL -
PHP Pagination with Next & Previous Functionality
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.
