[GeorgeBrown]

What's wrong with this code? it compiles well, but in game i got a mysql error

Quote:

Error in mysql_query: 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, Ownable=1 WHERE id=198' at line 1

Код:

forward MySQLUpdateCityCar(playerid);
public MySQLUpdateCityCar(playerid) // by Brown
{
	new query[512];
	new owner[32], description[32], plate[32];
	new vehid = GetPlayerVehicleID(playerid);
	samp_mysql_real_escape_string(CityCarInfo[vehid][cOwner], owner);
	samp_mysql_real_escape_string(CityCarInfo[vehid][cDescription], description);
	samp_mysql_real_escape_string(CityCarInfo[vehid][cPlate], plate);
        new currentveh = GetPlayerVehicleID(playerid);
	format(query, sizeof(query), "UPDATE citycars SET x=%f, y=%f, z=%f, a=%f, color1=%d, color2=%d, fraction=%d, Plate='%s', Owner='%s', Description='%s', Value=%d, Owned=%d, Lock=%d, Ownable=%d WHERE id=%d",
	CityCarInfo[vehid][cXPos],
	CityCarInfo[vehid][cYPos],
	CityCarInfo[vehid][cZPos],
	CityCarInfo[vehid][cAngle],
	CityCarInfo[vehid][cColorOne],
	CityCarInfo[vehid][cColorTwo],
	PlayerInfo[playerid][pLeader],
	plate,
	owner,
	description,
	CityCarInfo[vehid][cValue],
	CityCarInfo[vehid][cOwned],
	CityCarInfo[vehid][cLock],
	CityCarInfo[vehid][cOwnable],
	vehid);
	samp_mysql_query(query);
	return 0;
}