Проблема с запросом в БД

[Alex_Lenez]

Проблема такова пишет типа неправильный синтаксис языка SQL но как по мне то все верно !

Код ошибки:

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 `ID` = '1' at line 1

Сам запрос:

       new string[32],query[250];
        format(string,sizeof(string),"UPDATE `house` SET "),strcat(query,string);
        format(string,sizeof(string),"`EnterX` = '%f', ",HouseInfo[houseid][hEntrancex]),strcat(query,string);
        format(string,sizeof(string),"`EnterY` = '%f', ",HouseInfo[houseid][hEntrancey]),strcat(query,string);
        format(string,sizeof(string),"`EnterZ` = '%f', ",HouseInfo[houseid][hEntrancez]),strcat(query,string);
        format(string,sizeof(string),"`ExitX` = '%f', ",HouseInfo[houseid][hExitx]),strcat(query,string);
        format(string,sizeof(string),"`ExitY` = '%f', ",HouseInfo[houseid][hExity]),strcat(query,string);
        format(string,sizeof(string),"`ExitZ` = '%f', ",HouseInfo[houseid][hExitz]),strcat(query,string);
        format(string,sizeof(string),"`Owner` = '%s', ",HouseInfo[houseid][hOwner]),strcat(query,string);
        format(string,sizeof(string),"`Value` = '%i', ",HouseInfo[houseid][hValue]),strcat(query,string);
        format(string,sizeof(string),"`hHel` = '%i', ",HouseInfo[houseid][hHel]),strcat(query,string);
        format(string,sizeof(string),"`hInt` = '%i', ",HouseInfo[houseid][hInt]),strcat(query,string);
        format(string,sizeof(string),"`hLock` = '%i', ",HouseInfo[houseid][hLock]),strcat(query,string);
        format(string,sizeof(string),"`Number` = '%i', ",HouseInfo[houseid][hOwned]),strcat(query,string);
        format(string,sizeof(string),"`hTakings` = '%i', ",HouseInfo[houseid][hTakings]),strcat(query,string);
        format(string,sizeof(string),"`hVec` = '%i', ",HouseInfo[houseid][hVec]),strcat(query,string);
        format(string,sizeof(string),"`hVcol1` = '%i', ",HouseInfo[houseid][hVcol1]),strcat(query,string);
        format(string,sizeof(string),"`hVcol2` = '%i', ",HouseInfo[houseid][hVcol2]),strcat(query,string);
        format(string,sizeof(string),"`hKlass` = '%i', ",HouseInfo[houseid][hKlass]),strcat(query,string);
        format(string,sizeof(string),"`hVehSost` = '%i', ",HouseInfo[houseid][hVehSost]),strcat(query,string);
        format(string,sizeof(string),"`hCarx` = '%f', ",HouseInfo[houseid][hCarx]),strcat(query,string);
        format(string,sizeof(string),"`hCary` = '%f', ",HouseInfo[houseid][hCary]),strcat(query,string);
        format(string,sizeof(string),"`hCarz` = '%f', ",HouseInfo[houseid][hCarz]),strcat(query,string);
        format(string,sizeof(string),"`hCarc` = '%f', ",HouseInfo[houseid][hCarc]),strcat(query,string);
        format(string,sizeof(string),"`hMats` = '%i', ",HouseInfo[houseid][hMats]),strcat(query,string);
        format(string,sizeof(string),"`hStyle` = '%i', ",HouseInfo[houseid][hStyle]),strcat(query,string);
        format(string,sizeof(string),"`hSost` = '%i' ",HouseInfo[houseid][hSost]),strcat(query,string);
        format(string,sizeof(string),"WHERE `ID` = '%i' ",HouseInfo[houseid][hID]),strcat(query,string);
        mysql_function_query(g_CH, query, false, "","");

Помогите может и в правду что то не так!