Problems with SQL Query

[brunolopes]

Hello, people. ^_^

I am with a problem...
I need to return numbers with an SQL Query, like this:

function getNumber(cid)
   return db.executeQuery("SELECT `number` FROM `players` WHERE id = ".. getPlayerGUID(cid) .."")
end

print(getNumber(cid))

The table 'number' have a number, for example.

But the function don\'t print nothing

Can someone help me? I rep+

 

[hodleo]

function getNumber(cid)
	local result = db.getResult('SELECT `number` FROM `players` WHERE `id` = '.. getPlayerGUID(cid))
	local data = result:getDataInt('number')
	result:free()
	return data
end

print(getNumber(cid))

 

[brunolopes]

Really thank you, CyberM

 

[brunolopes]

@update

I have another problem!

If I have three columns on database, and I need to get the value of one. How will be the function? For example:

function getNumber(cid, column)

 

[chojrak]

function getValue(cid, column)
	local res, ret = db.getResult('SELECT `'.. column ..'` FROM `players` WHERE `id` = '.. getPlayerGUID(cid) ..';'), nil
	if res:getID() ~= -1 then
		ret = res:getDataString(column)
		if tonumber(out) then
			ret = tonumber(out)
		end
		res:free()
	end
	return ret
end

I.E.

local exp = getValue(cid, "experience")