Query
#5

Quote:
Originally Posted by ikey07
Посмотреть сообщение
That is such a odd way to do it, use print(query); check if it actually working that way.
If you are using format at all, then dont use strcat.

or do like this

pawn Код:
new string[64],query[1024];
strcat(query, "UPDATE `players` SET ");
format(string,sizeof(string),"`Admin` = '%d', ",PlayerInfo[playerid][pAdmin]); strcat(query,string);
format(string,sizeof(string),"`VIP` = '%d', ",PlayerInfo[playerid][pVip]); strcat(query,string);
format(string,sizeof(string),"`Weather` = '%d' WHERE `Account_ID` = '%d'",PlayerInfo[playerid][Account_ID]); strcat(query,string);
mysql_query(mysql, query);
also in your mysql_query, you use query, while in strcat you use qstr.
I did the "INSERT INTO" function using strcat and it worked fine
Reply


Messages In This Thread
Query - by K0P - 09.02.2016, 15:47
Re: Query - by ikey07 - 09.02.2016, 15:52
Re: Query - by K0P - 09.02.2016, 15:55
Re: Query - by ikey07 - 09.02.2016, 16:05
Re: Query - by K0P - 09.02.2016, 16:35

Forum Jump:


Users browsing this thread: 1 Guest(s)