Posts: 596
Threads: 75
Joined: Nov 2015
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