SQL syntax. - Printable Version

SQL syntax. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQL syntax. (/showthread.php?tid=652426)

SQL syntax. - lolya93 - 10.04.2018

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

Re: SQL syntax. - kovac - 10.04.2018

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);

Re: SQL syntax. - lolya93 - 10.04.2018

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);

Re: SQL syntax. - ThinAir - 10.04.2018

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);

Re: SQL syntax. - lolya93 - 10.04.2018

Quote:

Originally Posted by ThinAir

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

thanks

Re: SQL syntax. - ISmokezU - 10.04.2018

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);

Re: SQL syntax. - lolya93 - 10.04.2018

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