[HELP] mysql_direct_query in lua

[WorldArd 220]

HI

I need help with this

mysql_query    / It works perfect

Spoiler

function Getlinebanco()
            local rows = mysql_query("SELECT COUNT(id) FROM x.x WHERE id='"..pc.get_player_id().."'")
            return tonumber(rows[1][1])
 end

mysql_direct_query   / error

Spoiler

function Getlinebanco()
            local res1,rows = mysql_direct_query("SELECT COUNT(id) FROM x.x WHERE id='"..pc.get_player_id().."'limit 1;")
            return tonumber(rows[1][1])
 end

 

In mysql_direct_query  it does not work

[Shang 466]

Spoiler

local c,rows = mysql_direct_query("SELECT count(*) as count FROM x.x WHERE id = "..pc.get_player_id().." LIMIT 1;")
return tonumber(rows[1].count)

I hope it works.