get_theater.php

<?php
include('db/db.php');
//Database connection selection
$db=new db();
$db->db_connect();
$db->db_select();

$loc_id = $_REQUEST['loc_id'];

$today = date('Y-m-d');

$sql = "SELECT theatres.name,theatres.id from assign_show join theatres on assign_show.fk_theater_id = theatres.id where assign_show.fk_location_id='$loc_id' GROUP BY assign_show.fk_theater_id";
$result = mysql_query($sql);

$a="<option value=''>Select Theatre</option>";
while($row = mysql_fetch_array($result))
{
	$theatre_name = $row['name'];
	$id = $row['id'];
	$a.="<option value='$id'>".$theatre_name."</option>";
}

echo $a;
?>