prepare("
SELECT ps.*, p.project_name, p.project_id as project_code
FROM project_selections ps
JOIN projects p ON ps.project_id = p.id
WHERE ps.id = ? AND ps.client_id = ?
");
$stmt->execute([$selection_id, $_SESSION['client_id']]);
$selection = $stmt->fetch();
if (!$selection) {
header('Location: projects-list.php');
exit;
}
// Get selection criteria
$stmt = $pdo->prepare("SELECT * FROM selection_criteria WHERE selection_id = ? ORDER BY id");
$stmt->execute([$selection_id]);
$criteria = $stmt->fetchAll();
// Get member count
$stmt = $pdo->prepare("SELECT COUNT(*) FROM selection_members WHERE selection_id = ?");
$stmt->execute([$selection_id]);
$member_count = $stmt->fetchColumn();
$page_title = 'View Selection';
include 'client-portal-header.php';
?>