prepare("SELECT * FROM residents WHERE id = ?");
$stmt->execute([$resident_id]);
$resident = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$resident) {
header("Location: staff_dashboard.php");
exit;
}
// Fetch partners for the dropdown
$stmt = $pdo->query("SELECT id, name FROM partners ORDER BY name");
$partners = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
New Referral - Continuum Nexus