24.06.2012, 12:47
something like the following example. (i kept the query size low for clarity)
Which is why I'd try to increase the array size first, second method isn't very elegant.
Or sort the data into categorized tables.
pawn Код:
format(szQuery, sizeof(szQuery), "UPDATE players SET Cash = '%d', Deposit = '%d' WHERE ID='%d'", ...);
mysql_query(szQuery, THREAD_NO_RESULT, playerid, iConnectionHandle);
format(szQuery, sizeof(szQuery), "UPDATE players SET WRestricted = '%d', Age = '%d', WHERE ID='%d'", ...);
mysql_query(szQuery, THREAD_NO_RESULT, playerid, iConnectionHandle);
Or sort the data into categorized tables.