SQL problems

[watkins577]

I have a offer = db.getResult("SELECT * FROM `auction_system`") and Im trying to access the rows of 'offer' from there so I can list them in an FYI thing.

How can I carry on with this?

 

[slaw]

What exactly you want to do?

Display all offers / display specified offer?

I suppose you're trying to do first option, so here's an example:

local auctions = db.getResult("SELECT * FROM `auction_system`")
if(auctions:getID() == -1)
	error('result not set!')
	return true
end

local str = ""
repeat
	str = "\n" .. str .. auctions:getDataString("item_name")
until not(auctions:next())
auctions:free()

doPlayerPopupFYI(cid, "Auction list: " .. str)