I have created a compobox and selected District from address table. I have to take the district name as a key and filter "towns" from address table and it should be displayed in the second compobox. Anyone help me what code I can use for second compobox?
The code used for the first one is working :
<form name="select_category" action="../select_category.php" method="post" >
<select name="cate" id="cate" style="width:180px;" >
<option value="select">Select District</option>
<?
$new=mysql_query("select * from address order by district asc");
while ($new12=mysql_fetch_array($new))
{
?>
<option value="<?=$new12;?>"><?=$new12;?></option>
<? } ?>
</select>
</form>
Any one give me how to write the second one?