File: /var/www/nclive/technc/exam_links_list_select.php
<?php
include 'config.php';
header("Content-type:application/json");
$id = $_REQUEST['id'];
$query="SELECT el.id,el.exam_id,el.display_text, el.display_text_dates, el.description, el.links, el.date_type,el.date, el.status,e.exam_name,ee.name,el.entity_id FROM sp_exam_links as el
left join sp_exam as e on e.exam_id=el.exam_id
left join sp_exam_entity as ee on ee.id=el.entity_id where el.id='$id'";
$sql = $db->prepare($query);
$sql->execute();
$row = $sql->fetch();
echo json_encode($row , TRUE );
?>