query("SELECT title FROM exams WHERE id = $exam_id")->fetch_assoc(); // Fetch user answers $query = " SELECT ua.user_id, q.question_text, ua.selected_option, ua.submitted_at FROM user_answers ua JOIN questions q ON ua.question_id = q.id WHERE ua.exam_id = $exam_id ORDER BY ua.user_id, ua.submitted_at "; $result = $conn->query($query); ?>
| User ID | Question | Answer | Submitted At |
|---|---|---|---|