Retrieving multiple rows and presenting then in blocks

I would like to retrieve all the rows in result set and then present them 5 at a time with a next and prev button. I have tried this multiple ways with no luck. What are the possible ways to do this? Thanks

use limit in the select query

Okay, just spent an hour screwing around reading other posts and they are all in different starting positions with different methods so trying to follow code snippets and pieces of solutions is going nowhere. Can someone please just point me in the right direction to get started.

The term you’re looking for in pagination, try searching this forum for it. There are many, many examples detailing various solutions.