表格没有更新[重复]

Question

This question already has an answer here:

• When to use single quotes, double quotes, and backticks in MySQL 12 answers

I want to insert data into returnlist table and update the material table when i click the insert button. insertion works fine but the material table doesn't get updated.

<?php

    if(isset($_POST['submit'])){


    $Item = $_POST['Item'];
    $Quantity = $_POST['Quantity'];
    $Location = $_POST['Location'];
    $ReDate = $_POST['ReDate'];

    $query = mysql_query("INSERT INTO returnlist(Item,Quantity,Location,ReDate) VALUES ('$Item','$Quantity','$Location' ,'$ReDate')",$connection);
    $query = mysql_query("UPDATE material SET Quantity=Quantity + '$Quantity' WHERE 'Item'='$Item'", $connection);
    }

?>       

</div>

Answer 1

try this format

$query = mysql_query("UPDATE material SET `Quantity` = `Quantity` + '".$Quantity."' WHERE `Item` = '".$Item."'", $connection);