[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);

[Vince]

EnterX/Y/Z should be float, not varchar. Varchar is a string type.

[ReneG]

You don't need to insert values into auto increment fields since they're automatically filled with an increment (hence 'auto increment') Also, when all else fails, enable mysql_debug and see what prints out in mysql_log.txt.

[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);

[ReneG]

Maybe it's because you're trying to put an integer into a boolean field? I'm not too sure. Input these queries in the SQL tab in phpmyadmin.

[NewerthRoleplay]

Quote:

Originally Posted by VincentDunn Maybe it's because you're trying to put an integer into a boolean field? I'm not too sure. Input these queries in the SQL tab in phpmyadmin.

It worked perfectly with the SQL tab :S