<?php
    // Connect to the database
    include_once('config.php');

   // Get the selected category from the AJAX request
    $selectedCategory = $_POST['category'];

    // Fetch subcategories from the database for the selected category
    $query = "SELECT * FROM tbl_services WHERE m_id = '$selectedCategory'";
    $result = mysqli_query($db, $query);

    $subcategories = array();
    while ($row = mysqli_fetch_assoc($result)) {
        $subcategory = array(
            'subcategory_id' => $row['id'],
            'subcategory_name' => $row['name']
        );
        $subcategories[] = $subcategory;
    }

    // Send the subcategories as a JSON response
    echo json_encode($subcategories);
?>