[lolya93]

i have a sql syntax problem there is code:

Code:

	new Query[256], pName[35];
		new Float:x, Float:y, Float:z;

		GetPlayerName(playerid, pName, 35);
		GetPlayerPos(playerid, x, y, z);

		mysql_format(ConnectMySQL, Query, sizeof(Query), "UPDATE `aractrash` SET `tposX` = %f, `tposY` = %f, tposZ = %f, `KullaniciAdi` = %s)x, ,y ,z ,pName");
		mysql_tquery(ConnectMySQL, Query);

gives this.

Code:

error 076: syntax error in the expression, or invalid function call

[kovac]

You have put ) instead of " and forgot ,

PHP Code:

new Query[256], pName[35];
new Float:x, Float:y, Float:z;
GetPlayerName(playerid, pName, 35);
GetPlayerPos(playerid, x, y, z);
mysql_format(ConnectMySQL, Query, sizeof(Query), "UPDATE `aractrash` SET `tposX` = '%f', `tposY` = '%f', tposZ = '%f', `KullaniciAdi` = '%s'", x, ,y ,z ,pName);
mysql_tquery(ConnectMySQL, Query); 


[lolya93]

thanks but didn't work.

now gives that

PHP Code:

C:\Users\**\Desktop\3d\gamemodes\...pwn(288) : warning 215: expression has no effect
C:\Users\**\Desktop\3d\gamemodes\...pwn(288) : warning 215: expression has no effect
C:\Users\**\Desktop\3d\gamemodes\....pwn(288) : warning 215: expression has no effect
C:\Users\**\Desktop\3d\gamemodes\....pwn(288) : error 001: expected token: ";", but found ")"
C:\Users\**\Desktop\3d\gamemodes\...pwn(288) : fatal error 107: too many error messages on one line
Compilation aborted.Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase
4 Errors. 


PHP Code:

line 288
    mysql_format(ConnectMySQL, Query, sizeof(Query), "UPDATE `aractrash` SET `tposX` = '%f', `tposY` = '%f', tposZ = '%f', `KullaniciAdi` = '%s'", x, ,y ,z ,pName); 


[ThinAir]

Quote:

Originally Posted by kovac You have put ) instead of " and forgot , PHP Code: new Query[256], pName[35]; new Float:x, Float:y, Float:z; GetPlayerName(playerid, pName, 35); GetPlayerPos(playerid, x, y, z); mysql_format(ConnectMySQL, Query, sizeof(Query), "UPDATE `aractrash` SET `tposX` = '%f', `tposY` = '%f', tposZ = '%f', `KullaniciAdi` = '%s'", x, ,y ,z ,pName); mysql_tquery(ConnectMySQL, Query);

You have one extra comma ...'%s'", x, ,y ,z ,pName);

[lolya93]

Quote:

Originally Posted by ThinAir You have one extra comma ...'%s'", x, ,y ,z ,pName);

thanks

[ISmokezU]

PHP Code:

new Query[256], pName[35];
new Float:x, Float:y, Float:z;
GetPlayerName(playerid, pName, 35);
GetPlayerPos(playerid, x, y, z);
mysql_format(ConnectMySQL, Query, sizeof(Query), "UPDATE aractrash SET tposX = %f, tposY = %f, tposZ = %f, KullaniciAdi = %s", x, y, z, pName);
mysql_tquery(ConnectMySQL, Query); 


[lolya93]

Quote:

Originally Posted by ISmokezU PHP Code: new Query[256], pName[35]; new Float:x, Float:y, Float:z; GetPlayerName(playerid, pName, 35); GetPlayerPos(playerid, x, y, z); mysql_format(ConnectMySQL, Query, sizeof(Query), "UPDATE aractrash SET tposX = %f, tposY = %f, tposZ = %f, KullaniciAdi = %s", x, y, z, pName); mysql_tquery(ConnectMySQL, Query);

thanks guys.

PHP Code:

Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase
 no errors