Umm I think you can do LIMIT 0, 30
that's to start from the first record and go to the 30th and u use a loop to increase the 0 by 30.so on page 1 it will be from record 1 - 30 page 2 will be record 31 - 60 etc.
My version is a little longer than it could be but it works for me so
that's to start from the first record and go to the 30th and u use a loop to increase the 0 by 30.so on page 1 it will be from record 1 - 30 page 2 will be record 31 - 60 etc.
My version is a little longer than it could be but it works for me so