MYSQL Insert Into Problem
#1

I ran into a problem, making my car system, the problem is:

Quote:

[19:55:09] [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 ''-1.' at line 1
[19:58:35] [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 ''-1.' at line 1

And this is my MYSQL Code:

Quote:

saveCarToDB(playerid,carid)
{
new query[128];
format(query,sizeof(query),"INSERT INTO autos (besitzer,modelid,x,y,z,r,farbe1,farbe2) VALUES ('%s','%i','%f','%f','%f','%f','%i','%i')",getPlay erName(playerid),cInfo[carid][c_model],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r],cInfo[carid][farbe1],cInfo[carid][farbe2]);
mysql_function_query(dbhandle,query,false,"","");
return 1;
}

Reply


Messages In This Thread
MYSQL Insert Into Problem - by ImTobi - 18.12.2017, 18:03
Re: MYSQL Insert Into Problem - by Eoussama - 18.12.2017, 19:09
Re: MYSQL Insert Into Problem - by Logok987 - 19.12.2017, 13:20
Re: MYSQL Insert Into Problem - by ImTobi - 19.12.2017, 16:54

Forum Jump:


Users browsing this thread: 2 Guest(s)