<?php
include 'config.php';

 header("Content-type:application/json");

   $id = $_REQUEST['id'];
   $query="SELECT el.id,el.exam_id,e.exam_name, el.gender, el.categories, el.height,el.chest,el.race,el.long_jump,el.high_jump,el.short_put,el.chances FROM sp_physical_eligibility as el left join sp_exam as e on e.exam_id=el.exam_id where el.id='$id'";
	$sql = $db->prepare($query);
    $sql->execute();
	$row = $sql->fetch();

echo json_encode($row , TRUE );
?>