query("SELECT *,r.id as marksheet_id FROM results as r,students as s WHERE r.id = '$marksheet_id' and r.enrollment_no = s.enrollment_no"); // echo '
';
    // print_r($con);
    $__S = ($result->fetch_assoc());
    
    $institute = $con->query("SELECT * FROM centers where id = '".$__S['center_id']."'")->fetch_assoc();
    
    
    $courseDetails = $con->query("SELECT * FROM courses WHERE id = '".$__S['course_id']."'")->fetch_assoc();
    
    $course_duration = $courseDetails['duration'];
    $course_duration_type = ucfirst($courseDetails['duration_type']);
    $course_name = $courseDetails['course_name'];
    $course_id = $courseDetails['id'];
			
	 $bg = '../format/marksheet.jpg';
    $enroll_no = $__S['enrollment_no'];
    $photo = '../uploads/students/'.$__S['photo'];
    $serial_no = $__S['marksheet_id'];
    $sr_no = $__S['sr_no'];
    $res = $__S['result'];
    $sex = ucwords($__S['gender']);
    $name = ucwords($__S['name']);
    $father = ucwords($__S['father']);
    $dob = date('d-m-Y', strtotime($__S['dob']));
    $mother = ucwords($__S['mother']);
    // $course_name = ucwords($course['short_name']);
    // $duration=$course['duration'];
    $roll_no = $__S['roll_no'];
    $center_name = $institute['institute_name'];
    $center_number = $institute['center_number'];
    $issue_date = $__S['issue_date'];
    $isu = date('d-m-Y',strtotime($issue_date));
    $examination = date('M-Y',strtotime($issue_date));
    $grade = $__S['grade'];
    
    $hidden_duration = $__S['duration'];
    $examination_a = $__S['examination'];
    $session = $__S['session'];
    $duration = $__S['duration'] .' '. ucwords($__S['duration_type']);

       
    function sup($i)
{
    $i = ($i == 1) ? 'st' :
        (($i == 2) ? 'nd' :
            (($i == 3) ? 'rd' : 'th'));
    return '' . $i . '';
}

    include 'result.php';
}

?>