Php/mysql Record Pagination?

[Sarah]

I'm having trouble viewing mySQL database records if they are viewed by page. I know you need to use the "LIMIT" option in the SQL query.

I've got this funky for loop going, which seems to work, but there are things missing. Like having the link unclickable when you are viewing the certain page.

 

Could anyone give me a small rundown of the logic behind paginating this data? My code's getting too complex and I know there is an easier way.

 

Thanks!

[surefire]

Here you go

 

Tutorial