mysql error 1064 - Printable Version

mysql 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 1064 (/showthread.php?tid=300188)

mysql error 1064 - Cassely1704 - 29.11.2011

The error in the query:

PHP код:



format(query,sizeof(query),"UPDATE "TABLE_CARS" SET lock=%i, vehcoms='%s', paintjob=%i WHERE id=%i"

,CarInfo[c][cLock],CarInfo[c][cVehcom],CarInfo[c][cPaintjob],c);

mysql_query(query);

PHP код:



CMySQLHandler::Query(UPDATE cars SET lock=0, vehcoms='0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0', paintjob=0 WHERE id=1) - An error has occured. (Error ID: 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 'lock=0, vehcoms='0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0', paintjob=0 WHERE id=' at line 1)

Help, please!

Re: mysql error 1064 - TaMeD - 29.11.2011

PHP код:



mysql_query("UPDATE cars SET lock=0, vehcoms='0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0', paintjob=0 WHERE id=1");

That?

Re: mysql error 1064 - AndreT - 29.11.2011

What's the fieldtype for vehcoms?

Re: mysql error 1064 - Cassely1704 - 29.11.2011

Quote:

Originally Posted by TaMeD

PHP код:



mysql_query("UPDATE cars SET lock=0, vehcoms='0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0', paintjob=0 WHERE id=1");

That?

This is not a solution of the problem, but thank's

Quote:

Originally Posted by AndreT

What's the fieldtype for vehcoms?

varchar

Re: mysql error 1064 - Cassely1704 - 01.12.2011

i still need help