Mysql INSERT INTO Error
#1

Hello, This is my code:


Код:
	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);
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
Reply
#2

Fixed
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)