MySQL error - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL error (
/showthread.php?tid=460305)
MySQL error -
Binx - 27.08.2013
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`");
Re: MySQL error -
[HiC]TheKiller - 28.08.2013
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.