limit query for pagination in php

Question

I have some code that LIMITs data to display only 50 items per page. The column I'm using has many items, so I need to make those spread out across the pages.

 

below is my code