= 9 GROUP BY order_id "; $orderResult = mysqli_query($conn, $orderCheckQuery); while ($row = mysqli_fetch_assoc($orderResult)) { $order_id = $row['order_id']; // Check if at least one product for this order_id is already billed $billedCheckQuery = " SELECT 1 FROM tbl_dealer_ef_sub WHERE order_id = $order_id AND ref_order_id IS NOT NULL LIMIT 1 "; $billedResult = mysqli_query($conn, $billedCheckQuery); if (mysqli_num_rows($billedResult) > 0) { // Update unbilled products to 'cancelled' $cancelQuery = " UPDATE tbl_dealer_ef_sub SET stock_status = 'no stock' WHERE order_id = $order_id AND stock_status = 'ordered' AND ref_order_id IS NULL AND TIMESTAMPDIFF(HOUR, order_date_time, NOW()) >= 9 "; mysqli_query($conn, $cancelQuery); echo "Cancelled unbilled products for Order ID: $order_id
"; } } ?>