[Adi007]

Hello,

Is there a problem if i use multiple queryes in one stock? Like this:

format(query,sizeof(query),"HERE COMMAND");
mysql_query(connection,query,false);
format(query,sizeof(query),"HERE COMMAND");
mysql_query(connection,query,false);
format(query,sizeof(query),"HERE COMMAND");
mysql_query(connection,query,false);
format(query,sizeof(query),"HERE COMMAND");
mysql_query(connection,query,false);

I ask if is wrong this, because sometimes my string, "query", isn't cleared before formatting it, and that result a wrong query.

[Prokill911]

ZzZz

Pretty much completely wrong...

Example

PHP код:

new g_mysql_handle;
g_mysql_handle = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_DATABASE,MYSQL_PASSWORD);
format(query, sizeof(query), "Syntax here");
mysql_function_query(g_mysql_handle, query, true, "CALL-BACK-IF-ANY", "WHAT TO PASS"); 


Call-back-if-any - If you have a callback.. Put it there... If not
Replace it with ""
WHAT TO PASS..
Example.. PlayerID... "s",playerid

[Adi007]

There is no mysql_function_query in my plugin / include (a_mysql). I use plugin r39-3 from here:
https://github.com/pBlueG/SA-MP-MySQL/releases
wiki: https://sampwiki.blast.hk/wiki/MySQL/R33

[Adi007]

bump