My mySQL database table has around 200+ tables and it's doing this weird flashy thing as the page is being generated. I don't know if that's because my code is terrible or if it's just too many records to display on one page.

How can I limit the number of records to, say, 25 per page and have back and next buttons generated?