MySQL error - Printable Version

MySQL error - 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: MySQL error (/showthread.php?tid=598362)

MySQL error - andreistalker - 11.01.2016

This is not sending can somebody say me why?

PHP код:



new query[256], nume[144];

        GetPlayerName(playerid, nume, sizeof(nume));

        mysql_format(SQL, query, sizeof(query), "INSERT INTO `users` (`License`) VALUES (1) WHERE `Nume` = '%s';", nume);

        mysql_query(SQL, query);

Re: MySQL error - itsCody - 11.01.2016

PHP код:



new query[256], nume[144]; 

GetPlayerName(playerid, nume, sizeof(nume)); 

mysql_format(SQL, query, sizeof(query), "UPDATE `users` SET License = '1' WHERE Name = '%e'", nume); 

mysql_tquery(SQL, query, "", "");

Try that?