且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用php mysql更新表中的行

更新时间:2023-02-04 15:06:30

t1 =(从请求的
中选择quantity_app
,其中requested_id =

_POST [hidden]);


t2 =更新仓库
设定数量=数量 - 。


my query is here:

$t1 = "(select quantity_app
        from requested
        where requested_id = $_POST[hidden])";
$t2 = "update warehouse
       set quantity = quantity - " . $t1;



this query doesn't run please help me i don't know were i do it wrong!
the quantity_app column must subtract quantity column

t1 = "(select quantity_app from requested where requested_id =


_POST[hidden])";


t2 = "update warehouse set quantity = quantity - " .