An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds....
#2

you forgot some quotes in it

Code:
format(Query, sizeof(Query), "INSERT INTO `houses` (`hID`, `Owned`, `Owner`, `Discription`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `Level`, `Value`, `Healthx`, `Armourx`, `Hel`, `Arm`,`Int`,`Lock`,`Rooms`,`Rent`,`Rentabil`,`Takings`) VALUES (%d, 0, 'The State', `%s`,%f,%f,%f,%f,%f,%f,%d,%d,0,0,0,0,%d,1,0,0,0,0)",
hid,Description,EntX,EntY,EntZ,ExitX,ExitY,ExitZ,Level,Value,Int);
mysql_query(Query);
NOTE: Mistakes are marked in bold

NOTE2: i guess you made a typo in the query in INSERT INTO (at Discription , it should be Description )
Reply


Messages In This Thread
An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds.... - by rati555 - 14.09.2012, 19:36
Re: An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds.... - by Kirollos - 14.09.2012, 19:45

Forum Jump:


Users browsing this thread: 1 Guest(s)