mysql error
#1

Hello, i have an mysql error. Whats wrong with this?
Код:
format(query, sizeof(query), "INSERT INTO `phone_contacts` (where, name, phnumber) VALUES (%i, '%s', %i)", PlayerInfo[playerid][pID], inputtext, phnumber);
mysql_query(sqldb, query);
mysql_free_result();
Код:
[00:24:23] [DEBUG] mysql_query - connection: 1, query: "INSERT INTO `phone_contacts` (where, name, phnumber) VALUES (1, ", use_cache: true
[00:24:23] [DEBUG] CMySQLQuery::Execute - starting query execution
[00:24:23] [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, name, phnumber) VALUES (1, 'asd', 1234567)' at line 1
Reply


Messages In This Thread
mysql error - by n00el - 24.08.2014, 22:27
Re: mysql error - by n00el - 25.08.2014, 05:15
Re: mysql error - by Smally - 25.08.2014, 06:29
Re: mysql error - by HazardouS - 25.08.2014, 11:57
Re: mysql error - by F1aw1ess - 25.08.2014, 12:10

Forum Jump:


Users browsing this thread: 1 Guest(s)