File: /var/www/nclive/technc/nc_exam_tracker_exam_entity.php
<?php
include 'config.php';
header("Content-type:application/json");
$entityID = $_REQUEST['entity'];
$getLinks = "Select el.display_text, el.links, el.date_type, el.date, el.add_by,al.username as addBy,el.update_date, el.update_by, u.username as updateBy, el.update_date from sp_exam_links as el left join sp_admin_login as al on al.id=el.add_by left join sp_admin_login as u on u.id=el.update_by where el.id='$entityID'";
$sql = $db->prepare($getLinks);
$sql->execute();
$row = $sql->fetch();
echo json_encode($row , TRUE );
?>