I am aware of using
Code: Select all
SELECT field FROM table ORDER BY id DESC LIMIT xCode: Select all
SELECT field FROM table LIMIT y,zHowever, I need to be able to "combine" these so I can pull x rows starting with row y and most importantly, I need the data in descending order.
Can anyone recommend the best way to accomplish this?
Thanks for the help!
AT