Something went wrong with mysql
#1

Hello, im trying to save something which i scripted but idk why mysql is giving me errors.

PHP код:
mysql_format(connecTqueryBuffersizeof(queryBuffer), "UPDATE users SET vehnumber = %d, WHERE uid = %i"pInfo[playerid][pVNumber], pInfo[playerid][pID]);
mysql_tquery(connecTqueryBuffer); 
Mysql Error:

Код:
[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
Reply
#2

Remove the commas before WHERE.
Reply
#3

Thank you!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)