Hello again. Sorry for spaming with posts.
I have this query:
PHP Code:
formatex(szQuery, charsmax(szQuery), "UPDATE `%s` SET `frags` = '15' , `deaths` = '5' , `headshots` = '8' , `score` = '4' , `lastvisit` = '%s' , `total_played_time` = '%s' WHERE `name` = '%s'",
g_szTables[5],/* g_iPlayersInfo[id][Frags], g_iPlayersInfo[id][Deaths], g_iPlayersInfo[id][Headshots], g_iPlayersInfo[id][Score],*/ g_iPlayersInfo[id][LastVisit], g_iPlayersInfo[id][PlayedTime], g_iPlayersInfo[id][Name])
and this is how i create the table where i want to introduce that data from query
PHP Code:
"( `id` INT(11) NOT NULL AUTO_INCREMENT , `name` VARCHAR(36) NOT NULL , `ipaddress` VARCHAR(36) NOT NULL , `steamid` VARCHAR(36) NOT NULL , `frags` INT(11) NOT NULL , `deaths` INT(11) NOT NULL , `headshots` INT(11) NOT NULL , `score` INT(11) NOT NULL , `played_time` VARCHAR(33) NOT NULL , PRIMARY KEY (`id`))"
the problem is that the data from columns frags, deaths, headshots, score don t update just the last 2 of them. i tried with numbers (as you can see) but same thing. Some ideas?