num_rows > 0) { // Output data of each row while ($row = $result->fetch_assoc()) { if (getUserMemberStatus($row['user_id'])) { $member = "\u{2713}"; } else { $member = "\u{2717}"; } $indemnityPending = false; $userId = $row['user_id']; $stmt = $conn->prepare("SELECT user_id FROM membership_application WHERE user_id = ? AND accept_indemnity = 0 LIMIT 1"); $stmt->bind_param("i", $userId); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows > 0) { $indemnityPending = true; } $stmt->close(); echo ""; } } else { echo ''; } ?>

		First Name	Last Name	Email	Member	Indemnity	Date Joined	Verified
	" . htmlspecialchars($row['user_id']) . "	" . htmlspecialchars($row['first_name']) . "	" . htmlspecialchars($row['last_name']) . "	" . htmlspecialchars($row['email']) . "	" . $member . "	" . $indemnityPending . "	" . htmlspecialchars($row['date_joined']) . "	"; if ($row['is_verified'] != 1) { echo " Resend Email "; } else { echo "\u{2713}"; } echo "	Link Membership
No records found