SQL error. Need Help.

[moola]

SELECT i.*, u.username, u.email, g.gallery_name, CONCAT('http://tutaka.com/images/',u.username,'/', i.name, '.', type) AS image_url, CONCAT('http://tutaka.com/thumbs/',u.username,'/', i.name, '.jpg') AS thumb_url FROM images i LEFT OUTER JOIN galleries g ON i.gallery_id=g.gallery_id, users u WHERE i.user_id=u.user_id AND i.user_id=3 ORDER BY i.uploaded desc LIMIT -5,5

 

 

mySQL Says: 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 '-5,5' at line 1

 

 

I can't figure what the error is all about?

[hvle]

Limit (# of item to be display)/offset

 

so when you say LIMIT -5,5 You tell mysql to return -5 rows, which doesn't make sense.

 

# of item to be display have to be a positive integer.

[fenway]

Yeah, you can't use negative offsets anymore...

[hvle]

anymore?

does that mean mysql allowed negative offset before? fenway?

This is interesting

[fenway]

I believe there was a time when you could use a negative offset -- so that you could start at record 20 but get _all_ of the rest of them... instead of what you currently have to do, which is specify a ridiculously large integer just to be sure.