[NewerthRoleplay]

Tried removing the auto increment field (Should have said I already tried that) and I changed the rows in the table for the co-ordinates to float's. Still makes no difference :S Here is what the code is currently

pawn Код:

mysql_query("CREATE TABLE IF NOT EXISTS houseinfo(id INT AUTO_INCREMENT PRIMARY KEY, owner VARCHAR(32), owned BOOLEAN, interior INT, EnterX FLOAT, EnterY FLOAT, EnterZ FLOAT, price INT, level INT)", dbconnect);
    new sql[128], owner[128], owned;
    owner = "For Sale";
    owned = 0;
    format(sql, sizeof(sql), "INSERT INTO `houseinfo` (owner, owned, interior, EnterX, EnterY, EnterZ, price, level) VALUES (%s, %i, %i, %f, %f, %f, %i, %i)",owner, owned, houseint, x, y, z, housecost, houselevel);
    mysql_query(sql, dbconnect);