query("SELECT * FROM exams_by_students WHERE id = '$resultId' "); if($check->num_rows){ $row = $check->fetch_assoc(); $student = $con->query("SELECT * FROM students WHERE id = '".$row['student_id']."'")->fetch_assoc(); $course = $con->query("SELECT * FROM courses WHERE id = '".$row['course_id']."'")->fetch_assoc(); $exam = $con->query("SELECT * FROM exams WHERE id = '".$row['exam_id']."'")->fetch_assoc(); ?>
| Name | = $student['name'] ?> |
|---|---|
| Course | = $course['course_name'] ?> |
| Total Questions | = $row['max_marks']?> |
| Result | = round( ($row['total'] / $row['max_marks']) * 100 ) ?>% |