PHP Code:
formatex( szQuery2, 999, "INSERT INTO `match_players` (`steam_id`, `username`, `kills`, `deaths`, `team`, `match_id`) VALUES ('%s', '%s', '%d', '%d', '%d', '%s') ON DUPLICATE KEY UPDATE `steam_id` = '%s', `username` = '%s', `kills` = '%d', `deaths` = '%d' WHERE `steam_id` = '%s'", auth, name[id], pTempKills[id], pTempDeaths[id], Team[id], szLine, auth, name[id], pTempKills[id], pTempDeaths[id], auth)
Getting error:
PHP Code:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `steam_id` = 'STEAM_0:0:154554389'' at line 1