[PHP / MySQL] [HOWTO] select data and split on pages

[Superfun]

I found this on some website, eddited some stuff, but really usefull.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

HOWTO: SELECT data from a MySQL database, split it on multiple pages and display it using page numbers.

We have MySQL table called 'students' holding 90 records with the following fields:
Name

 

[Mindblaster7]

Good job SF
I already knew about the LIMIT, but could think of a way to make it move along with pages.
Thanks a bunch!

 

[s-p-n]

Cool but it'd be nice if allot of those conditions were expanded out and indented a little..

Nice though

 

[Masius]

That's pretty nice indeed. I've always wondered how I could sort out pagination.. with this brief explanation I think I got it now. Thanks ^^