โค้ด: เลือกทั้งหมด
<script language = "JavaScript">
//**** List Amphur (Start) ***//
function ListAmphur(SelectValue)
{
form2.ddlAmphur.length = 0
form2.ddlTambon.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
form2.ddlAmphur.options[form2.ddlAmphur.length]= myOption
form2.ddlAmphur.value= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM amphur ORDER BY AMPHUR_ID ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = <?=$intRows;?>;
mySubList = new Array();
strGroup = <?=$objResult["PROVINCE_ID"];?>;
strValue = "<?=$objResult["AMPHUR_ID"];?>";
strItem = "<?=$objResult["AMPHUR_NAME"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
form2.ddlAmphur.options[form2.ddlAmphur.length]= myOption
}
<?
}
?>
}
//**** List Amphur (End) ***//
//**** List Tambon (Start) ***//
function ListTambon(SelectValue)
{
form2.ddlTambon.length = 0
//*** Insert null Default Value ***//
var myOption = new Option('','')
form2.ddlTambon.options[form2.ddlTambon.length]= myOption
<?
$intRows = 0;
$strSQL = "SELECT * FROM Tambon ORDER BY TAMBON_ID ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$intRows++;
?>
x = <?=$intRows;?>;
mySubList = new Array();
strGroup = <?=$objResult["AMPHUR_ID"];?>;
strValue = "<?=$objResult["TAMBON_ID"];?>";
strItem = "<?=$objResult["TAMBON_NAME"];?>";
mySubList[x,0] = strItem;
mySubList[x,1] = strGroup;
mySubList[x,2] = strValue;
if (mySubList[x,1] == SelectValue){
var myOption = new Option(mySubList[x,0], mySubList[x,2])
form2.ddlTambon.options[form2.ddlTambon.length]= myOption
}
<?
}
?>
}
//**** List Tambon (End) ***//
</script>
โค้ด: เลือกทั้งหมด
<form id="form2" name="form2" method="post" action="_niadd.php" >
<select name="ddlProvince" id="ddlProvince" style="width:133px" onChange = "ListAmphur(this.value)">
<option selected value="0"></option>
<?
$strSQL = "SELECT * FROM province ORDER BY PROVINCE_ID ASC ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mysql_fetch_array($objQuery))
{
?>
<option value="<?=$objResult["PROVINCE_ID"];?>"><?=$objResult["PROVINCE_NAME"];?></option>
<?
}
?>
</select>
<select name="ddlAmphur" id="ddlAmphur" style="width:133px" onchange = "ListTambon(this.value)">
<option selected="selected" value="0"></option>
</select>
<select name="ddlTambon" id="ddlTambon" style="width:133px">
<option selected="selected" value="0"></option>
</select>
</form>