/*livesearch.js*/
var xmlhttp;
 
function showResult(str)
{
if (str.length==0)
  {
  document.getElementById("livesearch").innerHTML="";
  document.getElementById("livesearch").style.border="0px";
  return;
  }
xmlhttp=GetXmlHttpObject()
if (xmlhttp==null)
  {
  alert ("Your browser does not support XML HTTP Request");
  return;
  }
var url="livesearch.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged ;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}
function stateChanged()
{
if (xmlhttp.readyState==4)
  {
  document.getElementById("livesearch").innerHTML=xmlhttp.responseText;
  document.getElementById("livesearch").style.border="1px solid #A5ACB2";
 // document.getElementById("livesearch").style.cursor="default";
  }
}
 
function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
  {
  // code for IE7+, Firefox, Chrome, Opera, Safari
  return new XMLHttpRequest();
  }
if (window.ActiveXObject)
  {
  // code for IE6, IE5
  return new ActiveXObject("Microsoft.XMLHTTP");
  }
return null;
}

/*livesearch.php*/
<?php
 
$strSearchVal = $_GET['q'];
 
if (strlen($strSearchVal) < 1) {
 return false;
}
 
// Opens a connection to a MySQL server
$connection=mysql_connect ("localhost", "root", "");
if (!$connection) {
  die('Not connected : ' . mysql_error());
}
// Sanitize User Input for Security
$strSearchVal = mysql_real_escape_string($strSearchVal);
 
 
// Set the active MySQL database
$db_selected = mysql_select_db("hospitals_info", $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}
 
$strSQL = "SELECT DISTINCT area FROM hospital WHERE area like '$strSearchVal%'";
$result = mysql_query($strSQL)
or
 die("Query to get blah failed with error: ".mysql_error());
 
 
while ($a=mysql_fetch_array($result)) {
 echo  $a['area']."<br />";
}
 
 
 
?>