Lua Get Sql raw count.

[slavi]

I want to get the raw count of a table.
I use this to get raw count.

local query = db.storeQuery('SELECT COUNT(id) FROM ld_sql.players;')   
    local num = result.getDataInt('COUNT(id)', query)
    return num

But it's not working.

 

[Ninja]

local resultId = db.storeQuery("SELECT COUNT(1) AS count FROM ld_sql.players")
if resultId then
    local count = result.getDataInt(resultId, "count")
    result.free(resultId)
    return count
end

 

[slavi]

Exactly ~Ninja,
So i used it in wrong war
result.getDataInt('', resultId) -> result.getDataInt(resultId, '')

Thanks for tip ^^

@Ninja I want to get id by raw number

For example the row is 30

I want to get player Id in row 30, how to do so?

I get error even using this

SELECT LAST(id) AS lastRow FROM players;

 

[Ninja]

I want to get player Id in row 30, how to do so?

SELECT id FROM players LIMIT 30, 1

I get error even using this

SELECT LAST(id) AS lastRow FROM players;

There is no such aggregate function in MySQL.

SELECT id FROM players ORDER BY id DESC LIMIT 1

 

[slavi]

SELECT id FROM players LIMIT 30, 1

There is no such aggregate function in MySQL.

SELECT id FROM players ORDER BY id DESC LIMIT 1

yeah i get it after hard, i searched and get it, thanks anyway