MYSQL ERROR (error #1064) - Printable Version

MYSQL ERROR (error #1064) - 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 ERROR (error #1064) (/showthread.php?tid=535708)

MYSQL ERROR (error #1064) - memurt - 05.09.2014

PHP код:



 mysql_format(mysql, mquery, sizeof(mquery), "UPDATE `players` SET PlayerposX='%f', PlayerposY='%f', PlayerposZ='%f', Int=%d, Vw=%d, Health='%f', Armour='%f' WHERE ID=%d",

    pInfo[playerid][pX], pInfo[playerid][pY], pInfo[playerid][pZ], pInfo[playerid][pInt], pInfo[playerid][pVw],  pInfo[playerid][pHealth],  pInfo[playerid][pArmour], pInfo[playerid][Sqlid]);

    mysql_query(mysql, mquery);

Код:

[17:05:47] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `oyuncular` SET PlayerposX='%f', PlayerposY='%f', PlayerposZ='%f', Int=%d, Vw=%d, Health='%f', Armour='%f' WHERE ID=%d"
[17:05:47] [DEBUG] mysql_query - connection: 1, query: "UPDATE `oyuncular` SET PlayerposX='148.484', PlayerposY='-89.149", use_cache: true
[17:05:47] [DEBUG] CMySQLQuery::Execute - starting query execution
[17:05:47] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Int=0, Vw=0, Health='99.0', Armour='99.0' WHERE ID=1' at line 1

Re: MYSQL ERROR (error #1064) - memurt - 06.09.2014

UP ..

Re: MYSQL ERROR (error #1064) - TheNerka - 06.09.2014

Код:

 mysql_format(mysql, mquery, sizeof(mquery), "UPDATE `players` SET PlayerposX='%f', PlayerposY='%f', PlayerposZ='%f', Int='%d', Vw='%d', Health='%f', Armour='%f' WHERE ID='%d'",
pInfo[playerid][pX], pInfo[playerid][pY], pInfo[playerid][pZ], pInfo[playerid][pInt], pInfo[playerid][pVw],  pInfo[playerid][pHealth],  pInfo[playerid][pArmour], pInfo[playerid][Sqlid]); 
    mysql_query(mysql, mquery);

try this

Re: MYSQL ERROR (error #1064) - memurt - 06.09.2014

PHP код:



 mysql_format(mysql, mquery, sizeof(mquery), "UPDATE `players` SET `PlayerposX` = '%f', `PlayerposY` = '%f', `PlayerposZ` = '%f', `Int` = '%d', `Vw` = '%d', `Health` = '%.1f', `Armour` = '%.1f' WHERE ID=%d", 

    pInfo[playerid][pX], pInfo[playerid][pY], pInfo[playerid][pZ], pInfo[playerid][pInt], pInfo[playerid][pVw],  pInfo[playerid][pHealth],  pInfo[playerid][pArmour], pInfo[playerid][Sqlid]); 

    mysql_query(mysql, mquery);

Thanks, i solved the problem to use this code.