basic select query_sql problem

[Onairda]

Hi, i just thinking what is wrong with my script, why the npc dont show any data Thank you  /kiss 

 

 

prontera,159,180,4	script	Ladder	100,{
set .@count, query_sql ("SELECT char_id,value FROM `char_reg_num` WHERE key='reborncount' ORDER BY value DESC",.@charid,.@reborncount);

mes "[RebornLadder]";
for( set .@i, 0; .@i < .@count; set .@i, .@i+1) {
 query_sql "SELECT `name` FROM `char` WHERE char_id="+.@charid[.@i]+"",.@charname$;
 mes .@charname$+" "+.@reborncount[.@i];
}
close;

 

[Emistry]

your char_reg_num table has no data for the NPC to display it. have you checked that?

[Onairda]

On 9/21/2019 at 11:56 AM, Emistry said:

your char_reg_num table has no data for the NPC to display it. have you checked that?

as i checked my database sir. the reborncount is inside the char_reg_num . but still not displaying

[Zell]

The query is right. Can you show the register in the table?