query("SELECT * FROM results WHERE enrollment_no = '".$enroll_no."' "); if($totalGet->num_rows){ while($row = $totalGet->fetch_assoc()){ $marks = $con->query("SELECT * FROM marks_table WHERE result_id = '".$row['id']."'"); if ($marks->num_rows > 0) { while ($m = $marks->fetch_assoc()) { $sub = $con->query("SELECT * FROM subjects WHERE id = '".$m['subject_id']."' ")->fetch_assoc(); $totalMaxMarks += $sub['max_marks']; $totalObtainMarks += $m['marks']; } } } } echo '

'.round( $totalObtainMarks / $totalMaxMarks * 100,2).'%

'; echo '

'.my_grade( $totalObtainMarks / $totalMaxMarks * 100).'

'; $admit_card_url = BASE_URL . "/get_certificate.php?enrollment_no=" . urlencode($enroll_no) ; echo ''; ?>