Something went wrong with mysql - 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: Something went wrong with mysql (/showthread.php?tid=643457)
+- 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: Something went wrong with mysql (/showthread.php?tid=643457)
Something went wrong with mysql - AlexMSK - 20.10.2017
Hello, im trying to save something which i scripted but idk why mysql is giving me errors.
PHP код:
mysql_format(connecT, queryBuffer, sizeof(queryBuffer), "UPDATE users SET vehnumber = %d, WHERE uid = %i", pInfo[playerid][pVNumber], pInfo[playerid][pID]);
mysql_tquery(connecT, queryBuffer);
Код:
[16:24:08] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE uid = 4' at line 1
Re: Something went wrong with mysql - Konstantinos - 20.10.2017
Remove the commas before WHERE.
Re: Something went wrong with mysql - AlexMSK - 20.10.2017
Thank you!