SA-MP Forums Archive
SQL Error Syntax - 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: SQL Error Syntax (/showthread.php?tid=439116)



SQL Error Syntax - UnknownGamer - 23.05.2013

pawn Код:
mysql_query("UPDATE `ownedcars` SET Location_Y='%s'", CarInfo[idx][cLocationy]);
I need help on the slightest thing....

"CarInfo[idx][cLocationy]" How do I put that as a FLOAT? because I get warning tag mismatch errors, because its a float in the enum section, for the cars.

How do you use float in SQL?

Thanks


AW: SQL Error Syntax - IPrototypeI - 23.05.2013

you have use the placeholder %f and if you don`t use a hooked version of mysql_query or a #define
then you have to use even format or mysql_format