ผมสั่งยกเลิกใบสั่งซื้อแล้ว ให้อับเดท สตอค คืน แต่ทำแล้วมัน อับเดทให้ product เดียวอะครับ

<? 
    include("include/connection.php");
    include ("chk_session.php");
    include ("include/function.php");
    
    
    
    $sql ="
            DELETE FROM orders 
            WHERE orders_id = '$id'
    ";

    mysql_query($sql) or die( mysql_error() );
    
    
    $sql ="
            SELECT *
            FROM orders_detail
            WHERE orders_id = '$id';
    
    ";
    $result = mysql_query($sql) or die(mysql_error());
    while( $data = mysql_fetch_array($result)) {
        
            $productid  =$data['product_id'];
            $ordersquantity  =$data['orders_detail_quantity'];
                    
            $sql ="
                    SELECT *
                    FROM product
                    WHERE product_id = '$productid';
            
            ";
            $result = mysql_query($sql) or die(mysql_error());
            $data = mysql_fetch_array($result);
            
            $productquantity = $data['product_quantity'];
            
            $restore = $productquantity+$ordersquantity;
            
            $sql = "
                    UPDATE product
                    SET product_quantity = '$restore'
                    WHERE product_id = '$productid' 

            ";
            mysql_query($sql) or die( mysql_error() );
        
    }
    
            $sql ="
                    DELETE FROM orders_detail
                    WHERE orders_id = '$id'
            ";
        
            mysql_query($sql) or die( mysql_error() );


?>