MySQL error
#1

Hi,
I haven't scripted for awhile, so I forgot many things... Here are lines, which cannot be executed:
pawn Код:
new query[200];
        mysql_format(sql,query,200,"INSERT INTO `accounts` (`Skin`) VALUES ('%i') WHERE `Nickname` = '%e'",id,Name(playerid));
        mysql_query(sql,query);
Looks like I'm doing everything OK, but mysql_log gives me this:
pawn Код:
[19:08:14] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `Nickname` = 'My_Dog'' at line 1
What is wrong?
Reply


Messages In This Thread
MySQL error - by kamiliuxliuxliux - 17.02.2015, 16:51
Re: MySQL error - by HazardouS - 17.02.2015, 16:53
Re: MySQL error - by JeaSon - 17.02.2015, 16:56
Re: MySQL error - by kamiliuxliuxliux - 17.02.2015, 16:59

Forum Jump:


Users browsing this thread: 1 Guest(s)