Hi, i am picking out the last ten entries to my database but how can i pick out the next ten after that for instance:
I have this at the moment for picking out the entries:
sortcolumn is the date/time field:

PHP Code:
SELECT FROM table ORDER BY sortcolumn DESC LIMIT 10
What i want is to go to the next page and it picks out the next ten.
So something like

PHP Code:
SELECT FROM table ORDER BY sortcolumn DESC LIMIT 20;

then somehow knock off the first ten
I hope i make sense!

Any help apreciated.

David