MySQL save problem (BIG string)
#6

something like the following example. (i kept the query size low for clarity)
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);
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.
Reply


Messages In This Thread
MySQL save problem (BIG string) - by ryansheilds - 24.06.2012, 11:43
Re: MySQL save problem (BIG string) - by Grand_Micha - 24.06.2012, 11:54
Re: MySQL save problem (BIG string) - by ryansheilds - 24.06.2012, 12:09
Re: MySQL save problem (BIG string) - by iggy1 - 24.06.2012, 12:30
Re: MySQL save problem (BIG string) - by ryansheilds - 24.06.2012, 12:40
Re: MySQL save problem (BIG string) - by iggy1 - 24.06.2012, 12:47
Re: MySQL save problem (BIG string) - by ryansheilds - 24.06.2012, 12:58
Re: MySQL save problem (BIG string) - by ryansheilds - 24.06.2012, 21:02
Re: MySQL save problem (BIG string) - by Badger(new) - 24.06.2012, 21:28
Re: MySQL save problem (BIG string) - by ryansheilds - 24.06.2012, 21:53

Forum Jump:


Users browsing this thread: 1 Guest(s)