mysql - offset problem
Posted
by Phil Jackson
on Stack Overflow
See other posts from Stack Overflow
or by Phil Jackson
Published on 2010-06-17T07:21:19Z
Indexed on
2010/06/17
7:23 UTC
Read the original article
Hit count: 229
Hi, I recently posted a question about getting last 3 results in table in the correct order. I now want the get all comments apart from the last 3 in the correct order.
Here is my syntax;
SELECT * FROM (SELECT * FROM $table ORDER BY ID DESC OFFSET 3) AS T ORDER BY TIME_STAMP
the error i am receiving is;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OFFSET, 3) AS T ORDER BY TIME_STAMP' at line 1
I can't seem to get it to work. Any help much appreciated.
© Stack Overflow or respective owner