MySql modul

[Baster]

Hi.
How to get the data from the second or third row?

local query = mysql_query(handler, "select * from...");
local rowCount = mysql_num_row(query) // rowCount = 4

//Further

local data = mysql_fetch_row(query);

or

local data = mysql_fetch_assoc(query);



I have access to the data of the first row.

[Galin]

Code:

function queryGetAll(query)
{
    local result = [];
    local mysql_result = mysql_query(database, query);
        
    local count = mysql_num_rows(mysql_result);
    for(local i=0; i<count; i++)
    {
        result.push(mysql_fetch_assoc(mysql_result));
    }
        
    mysql_free_result(mysql_result);
        
    return result;
}

[Nubzior]

Squirrel Script

local result = mysql_query(mysqlHandler, "SELECT * FROM `player_items` WHERE `player_id` = " + getGUIDbyLogin(getPlayerName(pid)) + ";");
if(result)
{
	local row;
	while ((row = mysql_fetch_assoc(result)))
       {
		callClientFunc(pid, "giveItem", row["instance"], row["amount"]);
	}
 
	mysql_free_result(result);
}

[Baster]

Thank you, guys.