Mysql table

[kuba90pl]

Hey i got prob:

my code:

function stworzElementyDomu() 
local query = dbQuery( arp_db, "SELECT * FROM house") 
local result, numrows, errmsg = dbPoll ( query, -1 ) 
    if numrows > 0 then 
        for i,dom in ipairs (result) do 
            createObject(1239,result[i][1],result[i][2],result[i][3]) 
            outputChatBox("tworze") 
        end 
    end 
end 
addEventHandler("onResourceStart",root,stworzElementyDomu) 

its output error: createObject[expected number at argument @2 , got nil]

my mysql syntax:

i want to get ox,oy,oz and create there object for every house.Help please.

edit. fixed already. close please this thread.

[Kenix]

Try maybe i wrong...

function stworzElementyDomu( ) 
    local query = dbQuery( arp_db, "SELECT * FROM house" ) 
    local result, numrows, errmsg = dbPoll ( query, -1 ) 
    if numrows > 0 then 
        for i = 1,#result do 
            if result[i]["ox"] and result[i]["oy"] and result[i]["oz"] then 
                createObject( 1239,result[i]["ox"],result[i]["oy"],result[i]["oz"] ) 
                outputChatBox( "tworze" ) 
            end  
        end 
    end 
    dbFree( query ) 
end 
addEventHandler( "onResourceStart",resourceRoot,stworzElementyDomu ) 

[H5N1]

That would be better:

  
for k,v in ipairs(result) do 
    v["lx"] etc... 
end