Get character mysql information

[mayel]

I'm using this code when I want to get data from my mysql database, but it does only work with numbers:

local nameifon, res = 0, db.getResult("SELECT `name` FROM `players` WHERE `id` = 10;")
if res:getID() ~= -1 then
nameifon = res:getDataInt('name')
res:free()
end

Any idea?

 

[Cykotitan]

Use getDataString, if you are fetching a non-number column.
And for a small perfomance boost, add LIMIT 1 at the end of query (before ;).

 

[mayel]

It worked TYY so much