not saving correctly [MYSQL]
#4

When you are going to use string in a MYSQL QUERY, you have to put ' twice('%s') and also you don't have to use it for integers.Just strings.

Correct one;

PHP код:
format(Query500"UPDATE `playerdata` SET `age` = %d, `gender` = %d, `skin` = %d, `country` = %d, `email` = '%s', `admin` = %d, `helper` = %d, `moderator` = %d, `score` = %d, `money` = %d, `gold` = %d, `kills` = %d, `deaths` = %d, `experiencepoints` = %d, `experiencepointsneeded` = %d, `kicks` = %d, `bans` = %d, `banned` = %d, `playinghours`= %d, `secondslogged` = %d, `adminhelp` = %d WHERE `id` = %d"
Reply


Messages In This Thread
not saving correctly [MYSQL] - by lulo356 - 23.07.2015, 22:40
Re: not saving correctly [MYSQL] - by trablon - 23.07.2015, 22:45
Re: not saving correctly [MYSQL] - by lulo356 - 23.07.2015, 23:26
Re: not saving correctly [MYSQL] - by trablon - 23.07.2015, 23:32
Re: not saving correctly [MYSQL] - by M4D - 23.07.2015, 23:37
Re: not saving correctly [MYSQL] - by JaydenJason - 23.07.2015, 23:40
Re: not saving correctly [MYSQL] - by trablon - 23.07.2015, 23:43

Forum Jump:


Users browsing this thread: 1 Guest(s)