Combo box

PHP
1

hi guys,

i have 2combo box in my search engine…

first one is city
2nd one is area

i want when i select city then the second is automatically load area of the selected city…

the search.html code:

<table width=“83%” border=“0” align=“center” cellpadding=“1” cellspacing=“1”>
<tr>
<td height=“11” class=“formtext_style”>City </td>
<td><label>
<select name=“city” id=“city” class=“formdropdown_style” style=“width:150px” onchange=“getarea()”>
<option value=“” selected=“selected”>—Select the City Name—</option>
<option value=“<?php echo $row[‘city’];?>”><?php echo $row[‘city’];?></option>
<option value=“madurai”>madurai</option>
<option value=“chennai”>chennai</option>
<?php
$sql=mysql_query(“select * from directory1 group by city”);
while($row=mysql_fetch_array($sql))
{
?>
<?php
}
?>
</select>
</label></td>
</tr>
<tr>
<td class=“formtext_style”>Area</td>
<td><label>
<select name=“area” id=“area” class=“formdropdown_style” style=“width:150px”>
<option value=“” selected=“selected”>—Select the Area—</option>
<option value=“<?php echo $row[‘area’];?>”><?php echo $row[‘area’];?></option>
<option value=“arapalayam”>arapalayam</option>
<option value=“saidapet”>saidapet</option>
<?php
$sql=mysql_query(“select * from directory1 group by `area’”);
while($row=mysql_fetch_array($sql))
{
?>
<?php
}
?>
</select>
</label></td>
</tr>

    &lt;tr&gt;
      &lt;td height="11" class="search_names"&gt;&nbsp;&lt;/td&gt;
      &lt;td&gt;&lt;label&gt; &lt;br /&gt;
            &lt;input type="submit" name="Submit" value="Search" /&gt;
      &lt;/label&gt;&lt;/td&gt;
    &lt;/tr&gt;
  &lt;/table&gt;

tats all…i want solution for this pbm

2

Do a google for ‘AJAX’