Difference between revisions of "Query sql"

Latest revision as of 10:21, 24 June 2013

Syntax

• query_sql("your MySQL query"{, <array variable>{, <array variable>{, ...}}});
• query_logsql("your MySQL query"{, <array variable>{, <array variable>{, ...}}});

Description

Executes an SQL query. A 'select' query can fill array variables with up to 128 rows of values, and will return the number of rows (the array size).

Note that 'query_sql' runs on the main database while 'query_logsql' runs on the log database.

Examples

   set @nb, query_sql("select name,fame from `char` ORDER BY fame DESC LIMIT 5", @name$, @fame);
   mes "Hall Of Fame: TOP5";
   mes "1."+@name$[0]+"("+@fame[0]+")"; // Will return a person with the biggest fame value.
   mes "2."+@name$[1]+"("+@fame[1]+")";
   mes "3."+@name$[2]+"("+@fame[2]+")";
   mes "4."+@name$[3]+"("+@fame[3]+")";
   mes "5."+@name$[4]+"("+@fame[4]+")";

See Also

• http://dev.mysql.com/doc/refman/5.6/en/
• escape_sql;