MySQL - INSERT INTO error
#1

Код HTML:
CMySQLHandler::Query(INSERT INTO `game_logs` (`uid`,`owner`,`charid`,`adminid`,`kara`,`powod`) VALUES ('1','2', '102', '2', '9', 'test') - An error has occured. (Error ID: 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 '' at line 1)
Code:

Код HTML:
stock Punishment(type,playerid,admin,reason[],time)
{
	new query[256];
	new uid = GetFreeSQLUID("game_logs", "uid");
	format(query, sizeof(query), "INSERT INTO `game_logs` (`uid`,`owner`,`charid`,`adminid`,`type`,`reason`) VALUES ('%d','%d', '%d', '%d', '%d', '%s'",
	uid,PlayerInfo[playerid][pOwnerUID], PlayerInfo[playerid][pUID], PlayerInfo[admin][pOwnerUID], type, reason);
        mysql_query(query);
What is wrong?
Reply


Messages In This Thread
MySQL - INSERT INTO error - by Rdx - 19.02.2013, 13:20
Re: MySQL - INSERT INTO error - by FUNExtreme - 19.02.2013, 13:22
Re: MySQL - INSERT INTO error - by Rdx - 19.02.2013, 13:28
Re: MySQL - INSERT INTO error - by Vince - 19.02.2013, 13:35
Re: MySQL - INSERT INTO error - by Rdx - 19.02.2013, 14:02

Forum Jump:


Users browsing this thread: 1 Guest(s)