Inserting data from database to a table.

[wesoly136]

Hi!
Operating with databse queries is difficult for me :S
How to insert for example: all ids of guild owners to a table?
I tried something like that:

local owners = db.getResult("SELECT `ownerid` FROM `guilds`;")
local list = {}
	for i, tid in ipairs(owners) do
	list[i] = tid
end

But with no effect, no error in console.

 

[wesoly136]

Refresh :/

 

[andypsylon]

I think its better, write what you need to do with this script

 

[Cykotitan]

you are manipulating Lua tables
to insert into SQL table use db.executeQuery with INSERT INTO statement

also you aren't fetching result properly (or at all), see deathlist/frags talkaction for details

 

[wesoly136]

I just need to check if the loging in player is a leader of any guild, but I also wanted to know how to do that
EDIT
Solved my problem in other way

 

[Cykotitan]

next time write what you're trying to achieve in the main post.

proper condition is getPlayerGuildLevel(cid) == GUILDLEVEL_LEADER