[Pagalbos]Dėl MySQL užklausos

[DonatasP]

Sveiki, taigi turiu bėdą su užklausą kurią siunčiu... Man meta:

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 '' at line 1)

Užklausa:

	            format(query, sizeof(query), "INSERT INTO `cars` (Owner,Model,x,y,z,angle,health,price,Fuel) VALUES ('%s','560','%f','%f','%f','%f','100.0','5000','60'",GetPlayerNameEx(playerid),Mturgus[rand][0],Mturgus[rand][1],Mturgus[rand][2],Mturgus[rand][3]);
	            mysql_query(query);

Jei reikia viso kodo tai:

	if(dialogid == 852)
	{
	    if(response)
	    {
	        if(listitem == 0)
	        {
	            new query[220], rand = random(sizeof(Mturgus));
	            format(query, sizeof(query), "INSERT INTO `cars` (Owner,Model,x,y,z,angle,health,price,Fuel) VALUES ('%s','560','%f','%f','%f','%f','100.0','5000','60'",GetPlayerNameEx(playerid),Mturgus[rand][0],Mturgus[rand][1],Mturgus[rand][2],Mturgus[rand][3]);
	            mysql_query(query);
	            SendInfoMSG(playerid, "Sėkmingai nusipirkote \"Sultan\" mašiną");
                UserCar[ playerid ] = CreateCarForPlayer( playerid );
			}
		}
		return 1;
	}

[EdvardasK]

kur 

mysql_free_result();

? 

ir ten kur jau values užmiršai )

 

'60')"

Taip turėtu būti, ar ne?

Redaguota Gruodžio 23, 2013, nario EdvardasK

[bebras]

	            format(query, sizeof(query), "INSERT INTO `cars` (Owner,Model,x,y,z,angle,health,price,Fuel) VALUES ('%s','560','%f','%f','%f','%f','100.0','5000','60')",GetPlayerNameEx(playerid),Mturgus[rand][0],Mturgus[rand][1],Mturgus[rand][2],Mturgus[rand][3]);

EDIT: nemačiau kad Edvardas jau rado...

Redaguota Gruodžio 23, 2013, nario Bebras