i hav this code for autosuggest..
it retrieves the desired values from the datbase..
and produces a list..like in google..

however the values in the list cannot be selected using the arrow keys..
could anybody familiar with google suggest help me out with this..

am using this for an textbox in html file..!!

thanks in advance..

/*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 />";
}



?>

auto suggest and auto autocomplete are two different things..!! try to google for autocomplete script

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.