SQL : get a value from a column

[Cocodrilo]

How to get a string value from a column db? something like this:

local q = dbQuery(con, "SELECT * FROM t_ayuntamiento WHERE Cuenta=?",Cuenta) 
local result = dbPoll(q,-1) 
     
if tostring(result) == "Cocodrilo" then 
    outputChatBox(result.. " is into db") 
end 

[KariiiM]

Oboviously dbPoll is a table, you have to loop it to get the specify value

[Cocodrilo]

so how would it be? any function or example?

[Tox]

you can either loop;

for key, value in ipairs (result) do  
    outputChatBox(value.Cocodrilo.. " is into db") 
end 
  

or use the column name as lua index;

outputChatBox (result[1].Cocodrilo.. "is into db")  

[Simple0x47]

you can either loop;

for key, value in ipairs (result) do  
    outputChatBox(value.Cocodrilo.. " is into db") 
end 
  

or use the column name as lua index;

outputChatBox (result[1].Cocodrilo.. "is into db")  

I'll recommend to you to use the second method as it's fastest than the first one.

[KariiiM]

I'll recommend to you to use the second method as it's fastest than the first one.

local q = dbQuery(con, "SELECT * FROM t_ayuntamiento WHERE Cuenta=?",Cuenta) 
local result = dbPoll(q,-1) 
local data = result[1] --Define result[1] with data instead of repeating it everytime needed. 
outputChatBox (data.Cocodrilo.. "is into db")