Hello, may I ask your help guys on how to create a link or a button that will show the next record of a select query result. To explain further, I will create a table of users. The data will be fetched from mysql database then it will be presented in a html table but my problem is that it shows a lot of users. I mean it consumes all of the page just showing the table of all users.
What I want is to create a table w/c shows, for example, 10 rows of user data. Then there is a next record button w/c will show the next 10 rows of data and so on. I wasn't able to do the coding because I still don't know what code will I use for the next button. I only know how to fetch and display the data in a html table. Thanks in advance! 🙂