[marquezsanchez]

hi guys i have a mysql error 1064 , it an syntax error but i didnt found any error :

Error + query

Quote:

errorid = 1064, error = 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 '`hEnterPosX` = '1958.378295', `hEnterPosY` = '1343.157226', `hEnterPosZ` = '15.3' at line 1, callback = query = UPDATE `housedata` SET `hOwner` = 'Etat', `hToSell` = '1', `hOriginalPrice` = '20000' `hEnterPosX` = '1958.378295', `hEnterPosY` = '1343.157226', `hEnterPosZ` = '15.374607', `hExitPosX` = '123.123001', `hExitPosY` = '456.455993', `hExitPosZ` = '789.789001' `hStoredWeapon0` = '0', `hStoredWeapon1` = '0', `hStoredWeapon2` = '0', `hStoredWeapon3` = '0', `hStoredMoney` = '0' `hLocked` = '0', `hSecurityLevel` = '0', `hHasAlarm` = '0'

the code :

Quote:

PHP код: MysqlSaveHouse(houseId) {     new escapedQuery[512];     format(escapedQuery, sizeof(escapedQuery), "UPDATE `housedata` SET `hOwner` = '%s', `hToSell` = '%i', `hOriginalPrice` = '%i' \     `hEnterPosX` = '%s', `hEnterPosY` = '%s', `hEnterPosZ` = '%s', `hExitPosX` = '%s', `hExitPosY` = '%s', `hExitPosZ` = '%s' \     `hStoredWeapon0` = '%i', `hStoredWeapon1` = '%i', `hStoredWeapon2` = '%i', `hStoredWeapon3` = '%i', `hStoredMoney` = '%i' \     `hLocked` = '%i', `hSecurityLevel` = '%i', `hHasAlarm` = '%i'",     gHouseVar[houseId][hOwner], gHouseVar[houseId][hToSell], gHouseVar[houseId][hOriginalPrice], strfloat(gHouseVar[houseId][hEnterPos][0]), strfloat(gHouseVar[houseId][hEnterPos][1]),     strfloat(gHouseVar[houseId][hEnterPos][2]), strfloat(gHouseVar[houseId][hExitPos][0]), strfloat(gHouseVar[houseId][hExitPos][1]), strfloat(gHouseVar[houseId][hExitPos][2]),     gHouseVar[houseId][hStoredWeapon][0], gHouseVar[houseId][hStoredWeapon][1],gHouseVar[houseId][hStoredWeapon][2],gHouseVar[houseId][hStoredWeapon][3],     gHouseVar[houseId][hStoredMoney], gHouseVar[houseId][hLocked], gHouseVar[houseId][hSecurityLevel], gHouseVar[houseId][hHasAlarm]);          mysql_function_query(gConnection, escapedQuery, false, "", ""); }

[iGetty]

You haven't set to update WHAT house ID..

[marquezsanchez]

OMFG !! thx you

[iGetty]

Is it fixed? I hope so.

[marquezsanchez]

yes ^^.