MySQL Query gone wrong.
#3

Quote:
Originally Posted by smeti
Посмотреть сообщение
pawn Код:
format(str, sizeof(str), "UPDATE `playerinfo` SET `ip` = '%s' AND `admin` = %d WHERE `user` = '%s'", ip2, pInfo[playerid][Admin], pName(playerid));
Change:
pawn Код:
format(str, sizeof(str), "UPDATE `playerinfo` SET `ip` = '%s', `admin` = '%d' WHERE `user` = '%s'", ip2, pInfo[playerid][Admin], pName(playerid));
//or:
format(str, sizeof(str), "UPDATE `playerinfo` SET `ip` = '%s' WHERE `user` = '%s' AND `admin` = '%d' ", ip2, pName(playerid), pInfo[playerid][Admin]);
I already tried both, but it's okay. I found a alternative way to do it. Thanks though
Reply


Messages In This Thread
MySQL Query gone wrong. - by Toni - 30.10.2010, 23:12
Re: MySQL Query gone wrong. - by smeti - 31.10.2010, 06:16
Re: MySQL Query gone wrong. - by Toni - 31.10.2010, 06:50

Forum Jump:


Users browsing this thread: 1 Guest(s)