[Binx]

So I get this error

Код:

error 035: argument type mismatch (argument 3)

On line

pawn Код:

while(mysql_fetch_row(Query,"|"))

And the full callback is

pawn Код:

forward LoadHouses(houseid);
public LoadHouses(houseid)
{
    new Query[255], LoadString[128];
    format(Query, sizeof(Query), "SELECT * FROM houses1");
    mysql_query(Query, THREAD_NO_RESULT, houseid, iConnectionHandle);
    mysql_store_result();
    while(mysql_fetch_row(Query,"|"))
    {
        sscanf(Query, "p<|>e<is[24]iffffff>", HouseInfo[houseid]);
        if(!strcmp("For Sale!", HouseInfo[houseid][hOwner])) format(LoadString, sizeof(LoadString), "[HOUSE]\nPrice: %i", HouseInfo[houseid][hPrice]);
        else format(LoadString, sizeof(LoadString), "[HOUSE]\nOwner: %s", HouseInfo[houseid][hOwner]);

        HouseLabel[houseid] = Create3DTextLabel(LoadString, COLOR_YELLOW, HouseInfo[houseid][hExtX], HouseInfo[houseid][hExtY], HouseInfo[houseid][hExtZ], 20.0, 0, 0);
        HousePickup[houseid] = CreatePickup(1239, 1, HouseInfo[houseid][hExtX], HouseInfo[houseid][hExtY], HouseInfo[houseid][hExtZ], 0);
    }
    return 1;
}

E: Also, if I was to save houses, would I have to save it like above(individually) or could I use something like:
format(Query, sizeof(Query), "UPDATE * WHERE `houses1`");

[[HiC]TheKiller]

Not sure why that line would be returning that error, although try changing mysql_fetch_row to mysql_fetch_row_format. In regards to your other question, that statement is incorrect. If you're trying to update something like the owner to a specific value on all houses:

Код:

UPDATE [TABLENAME] SET [COLUMN] = [VALUE]

Just don't use a WHERE clause.