Does anybody knows how to handle displaying lots of data from a table? Maybe, First, Next, Previous, and Last record feature.
Please advise.
Dennis
use the sql LIMIT function
so if you have a hundred records, the first query is
SELECT * FROM table LIMIT 0, 20
show's the first 20 records. Then the next select...
SELECT * FROM table LIMIT 20, 20
and so on...
adam
Well, a good pagination is more than a few select statements. You might wanna look at some guestbook or forum scripts.
