How to insert multiple values from select into table?

[Protagonist95]

Can you give me a hint how do i insert values into table?

Heres the code i wrote

mytable = {}

function insertGangTable()
local connection = dbConnect( "sqlite", "data.db" )
local gang_list = dbQuery( connection, "SELECT id,name FROM gang_list" )
local gang_list_result = dbPoll(gang_list, -1)

if gang_list_result then
	for _,row in ipairs( gang_list_result ) do
		for _,value in pairs( row ) do
			table.insert(mytable,...) --- { [id] = "name" }
		end
	end
end
end

 

[NeXuS™]

mytable = {}

function insertGangTable()
	local connection = dbConnect( "sqlite", "data.db" )
	local gang_list = dbQuery( connection, "SELECT id,name FROM gang_list" )
	local gang_list_result = dbPoll(gang_list, -1)

	if gang_list_result then
		for _,row in ipairs( gang_list_result ) do
			mytable[row["id"]] = row["name"] --- { [id] = "name" }
		end
	end
end

 

Edited August 13, 2017 by NeXuS™

[Protagonist95]

1 hour ago, NeXuS™ said:

mytable = {}

function insertGangTable()
	local connection = dbConnect( "sqlite", "data.db" )
	local gang_list = dbQuery( connection, "SELECT id,name FROM gang_list" )
	local gang_list_result = dbPoll(gang_list, -1)

	if gang_list_result then
		for _,row in ipairs( gang_list_result ) do
			mytable[row["id"]] = row["name"] --- { [id] = "name" }
		end
	end
end

 

Thakns m8