permisi mastah, ane kan lagi buat aplikasi koneksi database MySQL, nah ane pengennya itu jika isi dari textbox berubah dia mengserch/mengeksekusi query gans.

ini scriptnya gans

<form method="post" action="kirim.php?op=send">

 <table>

 <tr><td width ='40%'>Nomor HP Tujuan</td><td>:</td><td><input type="text" name="nohp"></td></tr>

 

 <tr><td>Provider</td><td>:</td>

 <?php

 $no = substr($nohp,1,4);

 $query = "SELECT * FROM provider WHERE no= '$no'";

 $hasil = mysql_query($query);

 $prov = $data['provider']

 while($data = mysql_fetch_array($hasil))

 {

 echo "<td><input type="text" name="Provider" value=".$prov." ></td></tr>";

 } 

 ?>

 <tr><td>Nominal</td><td>:</td><td>

 

 <select name="modem">

 <?php

 

 $query = "SELECT * FROM produk WHERE no= 'provider'";

 $hasil = mysql_query($query);

 while($data = mysql_fetch_array($hasil))

 {

 echo "<option>".$data['provider']."</option>";

 }

 ?>

 </select>

 

 </td></tr>

 <tr><td>Harga</td><td>:</td><td><input type="text" name="nohp"></td></tr>

 <tr valign="top"><td>Keterangan</td><td>:</td><td><textarea name="pesan" rows="5"></textarea></td></tr>

 <tr><td></td><td></td><td><input type="submit" name="submit" value="Kirim SMS"></td></tr>

 </table>

 </form>

thanks gans