<?php
include 'config.php';

 header("Content-type:application/json");
 $id = $_REQUEST['id'];
 $query="Select ic.id,ic.institute_id,ic.course_id,i.institutions_name,GROUP_CONCAT(c.course_name) as cname from sp_institute_courses as ic
left join sp_institutions as i on i.id=ic.institute_id
left join sp_courses as c on c.id=ic.course_id where ic.institute_id='$id'";
$sql = $db->prepare($query);
    $sql->execute();
	$row = $sql->fetch();

echo json_encode($row , TRUE );
?>