Solved Get more than 1 result. (db.getResult)

[Nothxbye]

Hello Guys,
I've got a question. It's possible to get more than 1 result in one time using "db.getResult"?
For example i want to get EVERY house id if someone is owner in one script exute.
I tried with loop and insert it to table but doesn't work for me, like here:

for i = 1, 3 do
local result = db.getResult('SELECT `id` FROM `houses` WHERE `owner` > 0)
end
local tbl = {}
table.insert(tbl, result:getDataInt("id"))

Is possible to get that effect in another way? Or same way but correct.

 

[iKaS]

Check in 004-database.lua.

function Result:getRows(free)

I don't know if it's that you are searching.

 

[Darkhaos]

local result = db.getResult('SELECT `id` FROM `houses` WHERE `owner` > 0')
if result:getID() ~= -1 then
	while(true) do
		--here comes your code
	if not result:next() then break end
	end
end

 

[Nothxbye]

local result = db.getResult('SELECT `id` FROM `houses` WHERE `owner` > 0')
if result:getID() ~= -1 then
	repeat
		--here comes your code
	until not result:next()
end

This works! Thanks