prepare("
SELECT u.id, u.name, u.user_type, u.membership_type, u.profile_image, u.district, u.state, u.designation, md.designation_hindi
FROM users u
LEFT JOIN membership_designations md
ON u.membership_type = md.membership_type
AND u.designation = md.designation
WHERE u.status = 'approved'
AND md.status = 'active'
ORDER BY u.created_at DESC
");
$stmt->execute();
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
include 'header.php';
include 'navbar.php';
?>
Our Members
![<?php echo htmlspecialchars($user['name']); ?>](<?php echo $user['profile_image'] ? 'uploads/profiles/' . htmlspecialchars($user['profile_image']) : 'img/default-avatar.png'; ?>){kind=avatar}