SQL Pagination ERROR

FiveM Server Development Resource Support
, ,
1

Hi, I wanted to paginate a Query made with the script “oxmysql”, but I get an error making the query paged:

MySQL.query('SELECT id FROM player_ids WHERE sender = ? OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;', {identifier}, function(result)
    for key, row in pairs(result) do
        for id, value in pairs(row) do
            print(id, value)
        end
    end
end)

I get this and I don’t know what I am doing bad:

image
image1305×34 3.02 KB

2

All of my testing seems to have to use LIMIT offsetvalue,limitvalue
Example I used SELECT name FROM vehicles LIMIT 2,1;
image
image
The query skipped the “offsetvalue” number of entries, and returned the “limitvalue” number of entries after