<?php
include'dbc.php';
$sql6=mysqli_query($conn,"select order_id from tbl_order where cart_status= '0'") or die(mysqli_query($conn));
                   while ($row6=mysqli_fetch_assoc($sql6))
                   {
                   	 $order_orderid=$row6['order_id']; 

                   	 	$sql7=mysqli_query($conn,"select product_id from tbl_order_details where order_id= '$order_orderid'") or die(mysqli_query($conn));
                        while ($row7=mysqli_fetch_assoc($sql7))
                        {
                        	echo $orderdetails_productid=$row7['product_id'];

                        	$del=mysqli_query($conn,"delete from tbl_order_details where product_id='$orderdetails_productid' and order_id='$order_orderid'");
                        }	

                   }	 
?>