[Lua] Database Query problems.

[zippoxer]

I have this query:

local result = db.getResult("SELECT * FROM next_login_items WHERE player_id = " .. getPlayerGUID(cid));

I just want to get all the rows and loop over them. How can I do that?

 

[Cykotitan]

	local result = db.getResult("SELECT * FROM next_login_items WHERE player_id = " .. getPlayerGUID(cid) .. ";")
	if result:getID() ~= -1 then
		repeat
			local cur = result:getDataInt("NAME OF COLUMN")
			-- all your code here
		until not result:next()
		result:free()
	end

 

[zippoxer]

	local result = db.getResult("SELECT * FROM next_login_items WHERE player_id = " .. getPlayerGUID(cid) .. ";")
	if result:getID() ~= -1 then
		repeat
			local cur = result:getDataInt("NAME OF COLUMN")
			-- all your code here
		until not result:next()
		result:free()
	end

Thanks it's working!