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

Sponsor our Newsletter | Privacy Policy | Terms of Service