Simple select limit query
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:
What i want is to go to the next page and it picks out the next ten.
SELECT * FROM table ORDER BY sortcolumn DESC LIMIT 10;
So something like
I hope i make sense!
SELECT * FROM table ORDER BY sortcolumn DESC LIMIT 20;
then somehow knock off the first ten;
Any help apreciated.