function simpanDetailPurchaseOrder

function simpanDetailPurchaseOrder()
        {
            $db=$_POST;
            $query = $db->prepare("UPDATE tbdetailpurchaseorder INNER JOIN tbdetailpurchaserequest ON (tbdetailpurchaseorder.IDPurchaseRequest = tbdetailpurchaserequest.IDPurchaseRequest) SET tbdetailpurchaseorder.IDPurchaseOrder = :IDPurchaseOrder, tbdetailpurchaseorder.IDPurchaseRequest = :IDPurchaseRequest, tbdetailpurchaserequest.status = :status, tbdetailpurchaseorder.namaOrder = :namaOrder, tbdetailpurchaseorder.tanggalOrder = :tanggalOrder, tbdetailpurchaseorder.purchaseOrder = :purchaseOrder, tbdetailpurchaseorder.IDNamaSupplier = :IDNamaSupplier, tbdetailpurchaseorder.hargaBarang = :hargaBarang, tbdetailpurchaserequest.IDNamaBarang = :IDNamaBarang, tbdetailpurchaserequest.stock = :stock WHERE tbdetailpurchaseorder.IDPurchaseRequest = :IDPurchaseOrder");

            $query->BindParam(':IDPurchaseOrder', $IDPurchaseOrder);
            $query->BindParam(':IDPurchaseRequest',$IDPurchaseRequest);
            $query->BindParam(':status',$status);
            $query->BindParam(':namaOrder',$namaOrder);
            $query->BindParam(':tanggalOrder', $tanggalOrder);
            $query->BindParam(':purchaseOrder', $purchaseOrder);
            $query->BindParam(':IDNamaSupplier',$IDNamaSupplier);
            $query->BindParam(':hargaBarang', $hargaBarang);
            $query->BindParam(':IDNamaBarang', $IDNamaBarang);
            $query->BindParam(':stock', $stock);
            $query->execute();
        }