Mysql result returns nil

[Wei]

local checkSave = dbQuery( test_db, "SELECT * FROM accounts WHERE serial=?", getPlayerSerial(source) ) 
local result = dbPoll( checkSave, -1 ) 
outputChatBox(result[5]) 

Why does this return nil ?

[gokalpfirat]

Why you get 5th result from table? Maybe because of this.

[Jaysds1]

try this:

local checkSave = dbQuery( test_db, "SELECT * FROM accounts WHERE serial=?", getPlayerSerial(source) ) 
local result = dbPoll( checkSave, -1 ) 
for i,v in pairs(result)do 
     outputChatBox(i..":"..v) 
end 

[Wei]

ERROR: Troll-Login\server.lua:17: attempt to concatenate local 'v' (a table value)

[Wei]

ERROR: Troll-Login\server.lua:17: attempt to concatenate local 'v' (a table value)

[Jaysds1]

ok, try this:

local checkSave = dbQuery( test_db, "SELECT * FROM accounts WHERE serial=?", getPlayerSerial(source) ) 
local result = dbPoll( checkSave, -1 ) 
for i,v in pairs(result)do 
     for _,b in ipairs(v)do 
          outputChatBox(i..":"..b) 
     end 
end 

Edited March 3, 2013 by Guest

[Wei]

ERROR: Troll-Login\server.lua:17: attempt to concatenate field '?' (a nil value)

[Wei]

Fix It

[Jaysds1]

copy the code again from above, I've edited it