You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`darkmatter` = `darkmatter` - '0' WHERE `galaxy` = '1' AND `system` = '5' AND `p' at line 1 UPDATE xgp_galaxy SET `metal` = `metal` - '448412700', `crystal` = `crystal` - '0' `darkmatter` = `darkmatter` - '0' WHERE `galaxy` = '1' AND `system` = '5' AND `planet` = '11' LIMIT 1;