Raised This Month: $51 Target: $400
 12% 

OFFSET and FETCH sql bug?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
lexzor
Veteran Member
Join Date: Nov 2020
Old 05-05-2022 , 23:38   OFFSET and FETCH sql bug?
Reply With Quote #1

heyo. aren't OFFSET and FETCH available for amxx sql ?

Query:
PHP Code:
formatex(szQuerycharsmax(szQuery), "SELECT * FROM `%s` ORDER BY `points` DESC OFFSET 10 ROWS FETCH NEXT 15 ROWS ONLY"TABLE_NAME); 
Error:

Code:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OFFSET 10 ROWS FETCH NEXT 15 ROWS ONLY' at line 1
lexzor is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:20.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode