Syntax error - 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: Syntax error (/showthread.php?tid=587277)
+- 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: Syntax error (/showthread.php?tid=587277)
Syntax error - nezo2001 - 29.08.2015
I can't find the error?!
PHP код:
format(query, sizeof(query), "INSERT INTO cars (id, model, x, y, z, a, owner, owned, price, locked, color1, color2, cSale) VALUES ('%i', '%i', '%f', '%f', '%f', '%f', 'None', '0', '%i', '0', '0', '0', '0')", cAutoIncrease, GetVehicleModel(GetPlayerVehicleID(playerid)), x, y, z, a, price);
Код:
[17:14:45] [Mysql]INSERT INTO cars (id, model, x, y, z, a, owner, owned, price, locked, color1, color2, cSale) VALUES ('0', '560', '1630.447998', '-1089.381713', '23.611164', '144.053558', 'None', '0', '750000', '0',
Re: Syntax error - R0 - 29.08.2015
Nvm.
Re: Syntax error - nezo2001 - 29.08.2015
Quote:
|
Originally Posted by R0
 Put ` before and after each name like `id` and remove ' ' from the values like %f and replace the 0 in the values and put %d instead and put the zeros for the %d's that you just placed at the others things at the end of the query
|
Thank you anyway