Events Participants for March -2025
prefix . 'frmt_form_entry_meta';
$students = $wpdb->get_results("
SELECT
MAX(CASE WHEN meta_key = 'name-1' THEN meta_value ELSE NULL END) AS name,
MAX(CASE WHEN meta_key = 'email-1' THEN meta_value ELSE NULL END) AS email,
MAX(CASE WHEN meta_key = 'select-1' THEN meta_value ELSE NULL END) AS batch,
MAX(CASE WHEN meta_key = 'checkbox-1' THEN meta_value ELSE NULL END) AS event
FROM $table_name
GROUP BY
entry_id
ORDER BY
entry_id");
// Separate students by events
$cricket_students = [];
$book_students = [];
foreach($students as $student){
$events = explode(',',strtolower($student->event));
$events = array_map('trim', $events);
if(in_array('cricket',$events)){
$cricket_students[] = $student;
}
if(in_array('book',$events)){
$book_students[] = $student;
}
}
?>
Book
name); ?>
email); ?>
No students registered for cricket.
Cricket
name); ?>
email); ?>
No students registered for cricket.
