[1,2,3,4,5,6,7,8,9,10]

paginate three to a page... so limit the results set to 3.

"LIMIT 3"

[1,2,3]

page=2 ... ah, page param... so we need to add an offset for this query and get the next
four result in the table after three...

"LIMIT 3 OFFSET 3"
[4,5,6]

:D

page=3 ...ah ha!

"LIMIT 3 OFFSET 6"

[10,3,7]

eh... wtf? did someone just sort the table with RAND()? My pagination is broke!


better explanation:

http://www.petefreitag.com/item/451.cfm