need help with sqlite

[Sparrow]

I'm working in house systel with SQLite, and I got problem.

can't find a way to create houses from data base when resource start.

SQLite table:

executeSQLCreateTable("Houses", "houseID STRING, houseOwner STRING, housePrice STRING, houseX STRING, houseY STRING, houseZ STRING") 

I try this, but wont work:

function createHousesOnStart() 
    local result = executeSQLQuery("SELECT houseID,houseOwner,housePrice,houseX,houseY,houseZ FROM Houses WHERE houseID=?") 
    if (result) and (houseOwner == "None") then 
        house = createPickup(houseX, houseY, houseZ, 3, 1273, 0) 
    else 
        house = createPickup(houseX, houseY, houseZ, 3, 1272, 0) 
    end 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), createHousesOnStart) 

sorry because I don't speak arabic, I havn't arabic keys on my laptop

[JR10]

local result = executeSQLQuery("SELECT houseID,houseOwner,housePrice,houseX,houseY,houseZ FROM Houses WHERE houseID=?") 

IDوضعت علامة الاستفهام و لم تحدد ال

من الكود انا اعتقد انك تريد كل المعلومات

function createHousesOnStart() 
    local result = executeSQLQuery("SELECT * FROM Houses") 
    if (#result == 0) then return end 
    for index, row in pairs(result) do 
    local house 
    if (row.houseOwner == "None") then 
        house = createPickup(row.houseX, row.houseY, row.houseZ, 3, 1273, 0) 
    else 
        house = createPickup(row.houseX, row.houseY, row.houseZ, 3, 1272, 0) 
    end 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), createHousesOnStart) 

[TAPL]

Here is for arabic topic only

Moved to Scripting.

[Sparrow]

I'm arabic, but too slow in typing wth arabic words

it works jr10 thank you (شكرا )