<?php
// Include database connection
require_once 'db_connection.php';

// Check if ID is provided
if (!isset($_GET['id'])) {
    header("Location: sales.php");
    exit();
}

$saleId = intval($_GET['id']);

// Delete the sale
$query = "DELETE FROM sales WHERE id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $saleId);
$stmt->execute();

header("Location: sales.php");
exit();