I have search box that has auto complete from database(works fine).but I need when the user enter the value in textbox(address_name) the other textboxes value come from Mysql. I know I must using Ajax+php to do this but I don't know how to do it?. Please help me to solve this problem as soon as possible.
Thanks in Advance
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ajax Auto Suggest</title>

<script type="text/javascript" src="autocomplete/jquery-1.2.1.pack.js"></script>
<script type="text/javascript">
	function lookup(inputString) {
		if(inputString.length == 0) {
			// Hide the suggestion box.
		} else {
			$.post("autocomplete/rpc.php", {queryString: ""+inputString+""}, 

				if(data.length >0) {
	} // lookup
	function fill(thisValue) {
		setTimeout("$('#suggestions').hide();", 200);


<style type="text/css">
	body {
		font-family: Helvetica;
		font-size: 11px;
		color: #000;
	h3 {
		margin: 0px;
		padding: 0px;	

	.suggestionsBox {
		position: relative;
		left: 30px;
		margin: 10px 0px 0px 0px;
		width: 200px;
		-moz-border-radius: 7px;
		-webkit-border-radius: 7px;
		border: 2px solid #000;	
		color: #fff;
	.suggestionList {
		margin: 0px;
		padding: 0px;
	.suggestionList li {
		margin: 0px 0px 3px 0px;
		padding: 3px;
		cursor: pointer;
	.suggestionList li:hover {
		background-color: #659CD8;
<body bgcolor="teal" align="center" >
<h1 align="center" >
<label>Search by work Address</label> <input type="text" name="address_name" size="20" 

id="inputString"   onkeyup="lookup(this.value);"  onblur="fill();" >
<form name ="analysis"  method="POST"  action="update.php">
<div class="suggestionsBox" id="suggestions" style="display: none;">
				<img src="autocomplete/upArrow.png" style="position: 

relative; top: -12px; left: 30px;" alt="upArrow" />
				<div class="suggestionList" id="autoSuggestionsList">
<label>Work Number </label> <input type="text"  name="work_no" id="work_no" disabled 

value="test" size="20"/>
<label> Work Address </label><input type="text" name="work_address" disabled value="test" 

size="20"/ ></br>

<input type="button" name= "new" value="New" onclick="window.location.href='new.html'"  />
<input type="submit" name= "update"  value= "Edit" 

onclick="window.location.href='update.html'" />
<input type="reset" name= "delet"  value= "Delete" />
<input type="button" name= "main"  value= "Home" onclick="window.location.href='main.html'" 

rpc.php(for auto complete)
PHP Code:
// PHP5 Implementation - uses MySQLi.
    // mysqli('localhost', 'yourUsername', 'yourPassword', 'yourDatabase');
$db = new mysqli('localhost''root' ,'mysql''consultancy');
$db) {
// Show error if we cannot connect.
echo 'ERROR: Could not connect to the database.';
    } else {
// Is there a posted query string?
if(isset($_POST['queryString'])) {
$queryString $db->real_escape_string($_POST['queryString']);
// Is the string length greater than 0?
if(strlen($queryString) >0) {
// Run the query: We use LIKE '$queryString%'
                // The percentage sign is a wild-card, in my example of countries it works like this...
                // $queryString = 'Uni';
                // Returned data = 'United States, United Kindom';
                // eg: SELECT yourColumnName FROM yourTable WHERE yourColumnName LIKE '$queryString%' LIMIT 10
$query $db->query("SELECT work_address FROM analysis WHERE work_address LIKE '$queryString%' LIMIT 10");
$query) {
// While there are results loop through them - fetching an Object (i like PHP5 btw!).
while ($result $query ->fetch_object()) {
// Format the results, im using <li> for the list, you can change it.
                        // The onClick function fills the textbox with the result.
                        // YOU MUST CHANGE: $result->value to $result->your_colum
echo '<li onClick="fill(\''.$result->work_address.'\');">'.$result->work_address.'</li>';
                } else {
'ERROR: There was a problem with the query.';
            } else {
// Dont do anything.
// There is a queryString.
} else {
'There should be no direct access to this script!';