mysql

[Master_MTA]

hey there what is the wrong here 

addEvent('deletehouse',true)
addEventHandler('deletehouse',root,function(id)
local markers=getHouseFromID(id)
local data=getElementData(source,'mrkinf')
local xyz=tostring(data[2]..','..data[3]..','..data[4]..','..data[18]..','..data[19]..','..data[20]..','..data[5]..','..data[6])
local x1y1z1=tostring(data[7]..','..data[8]..','..data[9]..','..data[21]..','..data[22]..','..data[23]..','..data[10]..','..data[11])
dbQuery(db,"DELETE FROM house WHERE id=? AND price=? AND owner=? AND key=? AND qus=? AND answer=? AND email=? AND fristpos=? AND secpos=? AND creater=? AND isvip=? AND color=?", id,data[13],data[12],data[14],data[15],data[16],data[26],xyz,x1y1z1,data[17],data[27],data[25])
for k,v in ipairs(markers)do
if isElement(v) and getElementType(v)=='marker' then
destroyElement(v)
end
end
triggerClientEvent(source,'housewnds',source,2,false)
removeElementData(source,'mrkinf')
end)

the code is work but it doesn't delete the information of house from mysql

no thing in debugscript

 

Edited May 2, 2017 by Master_MTA

[3aGl3]

You should probably use this only:

DELETE FROM house WHERE id=?

Assuming of course that id is unique, as it should be in a good database.