sql query

[simplynice]

how about we add this every time we do the for loop:

 

set .@int, .@int++; // just like php and other programming language

 

 

How about:

 

set .@int, mysql_num_rows; // count the number of rows

[Brian]

set .@int, .@int++; // just like php and other programming language

 

rAthena already supports increment and decrement operators since r15982.

set .@int, mysql_num_rows; // count the number of rows

 

query_sql already returns the number of rows returned by a SELECT query. Example:

set .@num_rows, query_sql("SELECT `name` FROM `char` 
                           WHERE `name` LIKE '%test%'", .@name$);
mes .@num_rows + " names contain the word *test*";

[simplynice]

Thank you for this!