02.09.2012, 15:07
Hello, This is my code:
And this is my debug file:
[18:14:44] CMySQLHandler::Query(INSERT INTO `business` (`Name`, `Owned`, `Owner`, `PickupX`, `PickupY`, `PickupZ`, `Price`) VALUES ('test', 0, 0, '1815.4399) - 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 ''1815.4399' at line 1)
Where is the problem, i can`t find.
Thanks
Код:
format(sql, sizeof(sql), "INSERT INTO `business` (`Name`, `Owned`, `Owner`, `PickupX`, `PickupY`, `PickupZ`, `Price`) VALUES ('%s', 0, 0, '%f', '%f', '%f', '%d')", name, pX, pY, pZ, price); mysql_query(sql);
[18:14:44] CMySQLHandler::Query(INSERT INTO `business` (`Name`, `Owned`, `Owner`, `PickupX`, `PickupY`, `PickupZ`, `Price`) VALUES ('test', 0, 0, '1815.4399) - 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 ''1815.4399' at line 1)
Where is the problem, i can`t find.
Thanks