How To Paginate A Mysql Query That Depends On A For() Loop

i need to paginate the results of the php code shown below. I've tried out several possibilities but to no avail. So as not to tamper with the main script, I created several test c

Solution 1:

Make 2 queries, 1 to make the total count of your data and the second one to Limit which record are you showing Check both links to learn how to do that that easy way.