Hi, I have a auto complete script. I want to display the data in select box and also it takes some time to fetch the value from database. How do we make it faster.
<html>
<head>
<title></title>
<script type=”text/javascript” src=”javascripts/prototype.js”></script>
<script type=”text/javascript” src=”javascripts/effects.js”></script>
<script type=”text/javascript” src=”javascripts/controls.js”></script>
[B]auto.php
[code=php]</head>
<body>
<table>
<form method=”post” >
<tr >
<td> <input type=”text” name=”pname” id=”pname”>
<div id=”hint”></div>
</td>
</tr>
</table>
</body><script type=”text/javascript”>
new Ajax.Autocompleter(“pname”,”hint”,”server.php”);
</script>
</html>
[B]server.php
[code=php]<?php
include “config.php”;
$sql = “SELECT distinct title,id FROM jos_list_categories WHERE title LIKE ‘$_POST[pname]%'”;
$rs = mysql_query($sql) or die(mysql_error());
?>
<ul>
<? while($data = mysql_fetch_assoc($rs)) { ?>
<li style=”overflow-y:auto;overflow-x:none;border:1px medium #666666;”><? echo stripslashes($data[‘title’]);?></li>
<? } ?>
</ul>