SA-MP Forums Archive
MYSQL Problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL Problem (/showthread.php?tid=281520)


MYSQL Problem - [IL]HeHu - 06.09.2011

PHP код:
[17:30:05] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[17:30:05] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now. 
After I do this:
PHP код:
            format(query,sizeof(query),"SELECT (`balance`) FROM `baccounts` WHERE `bid` = '%i'",account);
            mysql_query(query); 
This is for the first error, and this is for the second:
PHP код:
             format(query,sizeof(query),"UPDATE `baccounts` SET `balance` = '%i' WHERE `bid` = '%i'",x,account);
             mysql_query(query); 


Re: MYSQL Problem - Cyanide - 06.09.2011

http://dev.mysql.com/doc/refman/5.0/...t-of-sync.html