[NewerthRoleplay]

Hey I am using mysql on my server with my script on and whenever I use the command: createhouse I get the message saying that it has been inputted into the the database, however when I enter the table using phpmyadmin it clearly has not here is the code to create the table and insert the data:

pawn Код:

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