Lua MySQL doubt

[Kirtash]

I'm trying to get the account id value when I have the account name, but it returns me a ''.
Anyone sees what's happening here?

account.name[cid] = db.getResult("select id from (select * from accounts where name = ".. db.escapeString(account.name[cid]) .. ") as res1")

Thanks
Kirtash~

 

[averatec]

select id as res1 from accounts where name = ".. db.escapeString(account.name[cid]) .. "

 

[Summ]

Either you try:
getAccountIdByAccount(accName)

or

local res = db.getResult("SELECT id FROM accounts WHERE name = ".. db.escapeString(account.name[cid]) .. ";")
if res:getID() ~= -1 then
  local id = res:getDataInt("id")
  -- do what you want with id
else
  -- account not found
end