show 5 records from DB on each page


Does anyone can tell me how to get 5 record from DB on each page and add pagination at the bottom of the page?
Thank you


You use the limit and offset clauses in MySQL for the pages. The buttons just store the values you need to send for the current location in the recordset


thank you for the tip :slight_smile: I will try