PHP MySQL Insert Statement

programming
1

For some reason this isn’t working, my mind is dead and this is probably a stupid mistake…

$name = strtolower($_POST['itemname']);
        $set = strtolower($_POST['set']);
        $Henergy = intval($_POST['Henergy']);
        $mEnergy = intval($_POST['Menergy']);
        $Hxp = intval($_POST['Hxp']);
        $attack = intval($_POST['attack']);
        $hp = intval($_POST['hp']);
        $money = intval($_POST['money']);
        $location = strtolower($_POST['location']);
        $sockets = intval($_POST['sockets']);
        
        $insert = "INSERT INTO items (name, attack, money, set, Henergy, Hxp, hp, location, sockets, maxEnergy) VALUES ('$name', '$attack', '$money', '$set', '$Henergy', '$Hxp', '$hp', '$location', '$sockets', '$mEnergy')";
        $add_item = mysql_query($insert)or die(mysql_error());

Error:
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 'set, Henergy, Hxp, hp, location, sockets, maxEnergy) VALUES (‘test’, ‘0’, ‘0’, ‘’ at line 1