How to display multiple rows of result from SQL query using NPC

[gleynn]

Hi,

I have my sample npc script below with SQL query. In database, it has multiple rows of result.
can you please show me how can i make the dispbottom to reflect the first 3 rows of result?
 

izlude,117,110,6	script	sample	952,{

	input .@item_id;
	query_sql("SELECT char_id, nameid, amount FROM `inventory` HAVING nameid = "+.@item_id+" ORDER BY amount DESC",.@charid,.@nameid,.@amnt);
	dispbottom .@charid+" : "+getitemname(.@nameid)+" "+.@amnt+"pcs";
	end;
}

 

[Emistry]

On 12/28/2022 at 4:34 AM, gleynn said:

how can i make the dispbottom to reflect the first 3 rows of result?

input .@item_id;
.@size = query_sql("SELECT char_id, nameid, amount FROM `inventory` HAVING nameid = "+.@item_id+" ORDER BY amount DESC LIMIT 3",.@charid,.@nameid,.@amnt);
for (.@i = 0; .@i < .@size; .@i++)
	dispbottom .@charid[.@i]+" : "+getitemname(.@nameid[.@i])+" "+.@amnt[.@i]+"pcs";
end;

 

[gleynn]

8 minutes ago, gleynn said:

Hi,

I have my sample npc script below with SQL query. In database, it has multiple rows of result.
can you please show me how can i make the dispbottom to reflect the first 3 rows of result?
 

izlude,117,110,6	script	sample	952,{

	input .@item_id;
	query_sql("SELECT char_id, nameid, amount FROM `inventory` HAVING nameid = "+.@item_id+" ORDER BY amount DESC",.@charid,.@nameid,.@amnt);
	dispbottom .@charid+" : "+getitemname(.@nameid)+" "+.@amnt+"pcs";
	end;
}

 

please ignore my question above, I found this very helpful guide by AnnieRuru