Neqste: Created page with "==Syntax== '''query_sql'''("your MySQL query"{, {, {, ...}}}); '''query_logsql'''("your MySQL query"{, {, {, ..."

2013-06-24T10:21:54Z

Created page with "==Syntax== *'''query_sql'''("your MySQL query"{, <array variable>{, <array variable>{, ...}}}); *'''query_logsql'''("your MySQL query"{, <array variable>{, <array variable>{, ..."

New page

==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]];

[[Category:Script Command]]

Query sql - Revision history

Neqste: Created page with "==Syntax== *'''query_sql'''("your MySQL query"{, {, {, ...}}}); *'''query_logsql'''("your MySQL query"{, {, {, ..."

Neqste: Created page with "==Syntax== '''query_sql'''("your MySQL query"{, {, {, ...}}}); '''query_logsql'''("your MySQL query"{, {, {, ..."