Question about mysql query
#1

Well for each
pawn Код:
format(query,sizeof(query),"UPDATE...
do i need to have mysql_query, so something like this (this is a example)
pawn Код:
format(query,sizeof(query),"UPDATE accounts SET AdminLevel = %d,Vip = %d WHERE Name = '%s'",PlayerAdmin,PlayerVIP,PlayerName);
mysql_query(query);
format(query,sizeof(query),"UPDATE accounts SET Cash = %d WHERE Name = '%s'",PlayerCash,PlayerName);
mysql_query(query);
or i can do this
2.
pawn Код:
format(query,sizeof(query),"UPDATE accounts SET AdminLevel = %d,Vip = %d WHERE Name = '%s'",PlayerAdmin,PlayerVIP,PlayerName);
format(query,sizeof(query),"UPDATE accounts SET Cash = %d WHERE NAME = '%s'",PlayerCash,PlayerName);
mysql_query(query);
Reply


Messages In This Thread
Question about mysql query - by Tanush123 - 16.02.2012, 22:38
Re: Question about mysql query - by [LoF]Zak - 16.02.2012, 22:46
Re: Question about mysql query - by Toreno - 16.02.2012, 22:49
Re: Question about mysql query - by Tanush123 - 16.02.2012, 22:52
Re: Question about mysql query - by Toreno - 16.02.2012, 22:54

Forum Jump:


Users browsing this thread: 1 Guest(s)