query("SELECT c.*, COUNT(j.id) as job_count
FROM categories c
LEFT JOIN jobs j ON c.id = j.category_id AND j.status = 'active'
GROUP BY c.id
ORDER BY c.name ASC");
$categories = $stmt->fetchAll();
include 'includes/header.php';
?>
📂 Job Categories
Explore job opportunities across different industries and sectors