[GeonMake]

pawn Код:

if(strcmp(cmd, "/createhouse", true) == 0)
    {
        if(IsPlayerConnected(playerid))
        {
            new Float:X, Float:Y, Float:Z;
            GetPlayerPos(playerid, X,Y,Z);
            new Int = 1;
            new Owner[256], Discription[256];
            format(Owner, sizeof(Owner), "The State");
            format(Discription, sizeof(Discription), "House Apartment");
            new Value = 45000;
            new Lock = 1;
            new Owned = 0;
            new World = 1;
            new Query[256];
            new x1 = 244.411987;
            new y1 = 305.032990;
            new z1 = 999.231995;
            new id;
            id = mysql_num_rows()+1;
            format(Query, sizeof(Query), "INSERT INTO `house` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Int`, `Lock`, `Owned`, `World`) VALUES ('%d', '%f', '%f', '%f', '%f', '%f', '%f', '%s', '%s', '%d', '%d', '%d', '%d', '%d')", id, X,Y,Z,x1,y1,z1,Owner,Discription,Value,Int,Lock,Owned,World);
            mysql_query(Query);
            mysql_free_result();
            return 1;
        }
        return 1;
    }

It disn`t working..when i write this command is not insering in data base tabel.

[Sufyan]

Quote:

mysql_debug(1);

and see what is problem

[GeonMake]

pawn Код:

[16:48:53] CMySQLHandler::Query(INSERT INTO `house` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Int`, `Lock`, `Owned`, `World`) VALUES ('0', '933.725830', '-1804.942138', '13.844137', '244.411987', '305.032989', '999.231994') - An error has occured. (Error ID: 1064, 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 '' at line 1)
[16:48:53] >> mysql_free_result( Connection handle: 1 )
[16:48:53] CMySQLHandler::FreeResult() - The result is already empty.

[fordawinzz]

try using id = mysql_insert_id();

[Sufyan]

id filled is Integer? if it is then use

Quote:

format(Query, sizeof(Query), "INSERT INTO `house` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Int`, `Lock`, `Owned`, `World`) VALUES (%d, '%f', '%f', '%f', '%f', '%f', '%f', '%s', '%s', '%d', '%d', '%d', '%d', '%d')", id, X,Y,Z,x1,y1,z1,Owner,Discription,Value,Int,Lock,Ow ned,World);

[GeonMake]

Not working

[fordawinzz]

then set the id to AUTO_INCREMENT in the database

[[MG]Dimi]

Also understand one thing people: Saving Data or Making new row doesn't need mysql_free_result(); since it's not returning anything from mysql! And yes, delete your ID from query. In Table create Integer column and set auto-increment.

[Rob_Maate]

^^mysql_free_result(); expects parameters which you aren't supplying.

Since you haven't actually retrieved information from the database, obviously there is no result, meaning there's no result to free. Delete that line and have a go.

[GeonMake]

It doesn`t work..i don`t know why..maybe is from command?

pawn Код:

[01:23:03] CMySQLHandler::Query(INSERT INTO `house` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Int`, `Lock`, `Owned`, `World`) VALUES ('0', '909.684692', '-1802.042968', '13.770242', '0.000000', '0.000000', '0.000000', 'The) - An error has occured. (Error ID: 1064, 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 ''The' at line 1)