使用通配符查询数据库就可以了:
select * from tbl where field like '".$inputboxvalue."%'$inputbox;
$sql="select * from tbl where field like '".$inputboxvalue."%'"
mysql_query($sql)
while($obj=mysql_fetch_object())
{
    echo $obj->field;
}

解决方案 »

  1.   

    test2.php:
    <input name=root maxlength=1 onkeyup="getData(this.value)">
    <div id=listData></div>
    <IE:Download ID="oDownload" STYLE="behavior:url(#default#download)" />
    <script language=JScript>
    var aa="";
    function onDownloadDone(s){
    aa=s;
    document.all.listData.innerHTML=aa;
    }
    function getData(val)
    {
    document.all.listData.innerHTML="";
    oDownload.startDownload('test.php?key='+val,onDownloadDone);
    }
    </script>test.php:
    <?
    $arr=array( 'a'=>array('aa','ab','ac'),
    'b'=>array('ba','bb','bc'),
    'c'=>array('ca','cb','cc'));
    if(in_array($key,array_keys($arr))){
    $tmpArr=$arr[$key];
    echo "<select name=aaa>";
    for($n=0;$n<count($tmpArr);$n++){
    echo "<option value=".$n.">".$tmpArr[$n];
    }
    echo "</select>";
    }
    ?>