Mysql_query(SELECT) into variable

05/03/2014 17:30 Burbank#1

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

Quote:

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

05/03/2014 17:33 MrPlayboy#2

Try:

Code:

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

05/03/2014 18:45 Lord iRemix#3

Code:

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

05/04/2014 22:00 Burbank#4

It doesn't work.Any other ideas?