1) { $add = "UPDATE $usertype SET `$name` = `$name` - 1 WHERE name='$username'"; $res = mysqli_query($conn, $add); } else { echo ""; } } else { // Handle the SQL query error echo "Error: " . mysqli_error($conn); } } echo ""; ?>