Modules/MySQL/MysqlQuery

Description

This functions queries the MySQL server through the MySQL connection that has been opened by mysqlOpen. The result of the query is then passed to the script by calling callback_function.

This function is provided by the ml_mysql module.

Syntax

bool mysqlQuery ( [string callback_function, string query] )

Required Arguments

• callback_function : The function that is called if the operation is done (please see below)
• query : The MySQL query that is sent

Callback Arguments

Your callback function has to accept the following arguments:

• mysql_result rows : Returns the rows in a mysql_result array type
• bool result : Returns false on error, true on success

Optional Arguments

None

Example

 function onMySQLResult ( mysql_result, rows )
   if ( rows > 0 )
     -- we got a valid result, so let's process it
     -- we're only expecting 1 row to return (there shouldn't be any nick duplicates)
     player_nick = mysqlGetRow ( mysql_result, 0, 0 );
     player_money = mysqlGetRow ( mysql_result, 0, 1 );
     player_carid = mysqlGetRow ( mysql_result, 0, 2 );
   else
     -- no rows were returned
   end
 end
 <...>
 mysqlQuery ( "onMySQLResult", "SELECT `nickname`,`money`,`carid` FROM `rpg_players` WHERE `nickname` = 'ORLY'" );