(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for t

(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for t - 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: (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for t (/showthread.php?tid=574935)

(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for t - SandKing94 - 22.05.2015

My code:

Code:

format(query,sizeof(query),"UPDATE players SET Admin='%d' , Money='%d' , Skin='%d' , X='%f' , Y'%f' , Z='%f' , Angle='%f'",pInfo[playerid][Admin], pInfo[playerid][Money], pInfo[playerid][Skin], pInfo[playerid][Pos][0], pInfo[playerid][Pos][1], pInfo[playerid][Pos][2], pInfo[playerid][Pos][3]);
    mysql_function_query(Connection,query,false,"","");

Error:

Code:

[10:52:56] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE players SET Admin='0' , Money='99500' , Skin='0' , X='149", callback: "(null)", format: "(null)"
[10:52:56] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[10:52:56] [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 ''-67.215164' , Z='1.429687' , Angle='269.999969'' at line 1
[10:52:56] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Re: (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version f - Deathlane - 22.05.2015

You forgot the WHERE clause in your query.

Re: (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version f - SandKing94 - 22.05.2015

Thank you buddy, REP+

Re: (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version f - Smileys - 22.05.2015

Also, why do you put integers between quotes('%d')?

just put them as %d.

ONLY put strings between single quotes, like: '%s'