[Markski]

You seem to be feeding mysql_format a string. Use it like this instead.

Code:

mysql_format(SQL, query, sizeof(query), "INSERT INTO `houses` (`EnterX`, `EnterY`, `EnterZ`, `Price`) VALUES ('%f', '%f', '%f', '%d')", x, y, z, price);

Also, why are the variables x, y and z when at the top of the command you create pX, pY and pZ? Are they defined and set somewhere else?

If that doesn't work, make sure the fields in the MySQL database aren't defined as integers