Mysql_query(SELECT) into variable

[Burbank]

Hello, I have the problem.I need rewrite some informations with using mysql_query(SELECT) into my variable.I have table "pvp" in player into which is writing number of kills.
There is my quest but It doesn't work. Could you help me please? Thx

local kills = mysql_query("SELECT kills FROM player.pvp WHERE name = '"..pc.get_name().."';")
if kills == 100 then
say(" You're good. ")
else
say(" noob ")
end

[MrPlayboy]

Try:

local kills = mysql_query("SELECT pvp FROM player.player WHERE name = '"..pc.get_name().."';")

[Lord iRemix]

local kills = mysql_query("SELECT kills FROM player.pvp WHERE name = '"..pc.get_name().."';")[1][1]

[Burbank]

It doesn't work.Any other ideas?