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: 232

Filed under:
|
|
|

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

Related posts about mysql

Related posts about error