[Help] MySQL
#1

I'm having a problem with saving (updating) ints/floats.
Theres no problem with saving strings.

Anyway, I'm using the query builder..

pawn Код:
public MySQLSaveHouse(houseid)
{
    MySQLCheckConnection();
    format(query, MAX_STRING, "UPDATE houses SET ");
    MySQLUpdateFlo(query, HouseInfo[houseid][hSQLID], "Entrance_X", HouseInfo[houseid][hEntrancex], MYSQL_ID_HOUSE);
    MySQLUpdateFlo(query, HouseInfo[houseid][hSQLID], "Entrance_Y", HouseInfo[houseid][hEntrancey], MYSQL_ID_HOUSE);
    MySQLUpdateFlo(query, HouseInfo[houseid][hSQLID], "Entrance_Z", HouseInfo[houseid][hEntrancez], MYSQL_ID_HOUSE);
    MySQLUpdateInt(query, HouseInfo[houseid][hSQLID], "Price", HouseInfo[houseid][hPrice], MYSQL_ID_HOUSE);
    MySQLUpdateStr(query, HouseInfo[houseid][hSQLID], "Description", HouseInfo[houseid][hDescription], MYSQL_ID_HOUSE);
    MySQLUpdateFinish(query, HouseInfo[houseid][hSQLID], MYSQL_ID_HOUSE);
    return 1;
}
Its not the whole code, but its just a part of it, (float, int and string saving).
Any ideas?
Reply


Messages In This Thread
[Help] MySQL - by Maxips2 - 11.11.2010, 13:42
Re: [Help] MySQL - by Scenario - 11.11.2010, 13:47
Re: [Help] MySQL - by Maxips2 - 11.11.2010, 13:50
Re: [Help] MySQL - by Scenario - 11.11.2010, 13:53
Re: [Help] MySQL - by Maxips2 - 11.11.2010, 16:04
Re: [Help] MySQL - by Scenario - 11.11.2010, 17:57
Re: [Help] MySQL - by Maxips2 - 11.11.2010, 19:20

Forum Jump:


Users browsing this thread: 2 Guest(s)