关联查询.给你一段我以前写的代码,你可以看看<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
var arrItems1 = new Array();
var arrItemsGrp1 = new Array();
<?
mobile_info_list();//调用php查询函数
?>
function selectChange(control, controlToPopulate, ItemArray, GroupArray)
{
var myEle ;
var x ;
for (var q=controlToPopulate.options.length;q>=0;q--) controlToPopulate.options[q]=null;
if (control.name == "firstChoice") {
}
myEle = document.createElement("option") ;
myEle.value = 0 ;
myEle.text = "ÇëÑ¡ÔñÊÖ»úÐͺÅ" ;
controlToPopulate.add(myEle) ;
for ( x = 0 ; x < ItemArray.length ; x++ )
{
if ( GroupArray[x] == control.value )
{
myEle = document.createElement("option") ;
myEle.value = x ;
myEle.text = ItemArray[x] ;
controlToPopulate.add(myEle) ;
}
}
}
// End -->
</script>
<form name=myChoices action="" method="post" onSubmit="return checkform_sort();">
<tr><td bgcolor="#dddddd" class="title_black" colspan=4>Ìí¼ÓÐÅÏ¢</td></tr>
<tr align="left">
<td width="20%">ÊÖ»úÆ·ÅÆ:</td>
<td width="30%"><SELECT id=firstChoice name=firstChoice onchange="selectChange(this, myChoices.secondChoice, arrItems1, arrItemsGrp1);"><option value=0>ÇëÑ¡ÔñÊÖ»úÆ·ÅÆ</option><?
mobile_sort_list();
?></select></td>
<td width="20%">ÊÖ»úÐͺÅ:</td>
<td width="30%"><SELECT id=secondChoice name=secondChoice>
</SELECT>
</form>
<!-- Begin
var arrItems1 = new Array();
var arrItemsGrp1 = new Array();
<?
mobile_info_list();//调用php查询函数
?>
function selectChange(control, controlToPopulate, ItemArray, GroupArray)
{
var myEle ;
var x ;
for (var q=controlToPopulate.options.length;q>=0;q--) controlToPopulate.options[q]=null;
if (control.name == "firstChoice") {
}
myEle = document.createElement("option") ;
myEle.value = 0 ;
myEle.text = "ÇëÑ¡ÔñÊÖ»úÐͺÅ" ;
controlToPopulate.add(myEle) ;
for ( x = 0 ; x < ItemArray.length ; x++ )
{
if ( GroupArray[x] == control.value )
{
myEle = document.createElement("option") ;
myEle.value = x ;
myEle.text = ItemArray[x] ;
controlToPopulate.add(myEle) ;
}
}
}
// End -->
</script>
<form name=myChoices action="" method="post" onSubmit="return checkform_sort();">
<tr><td bgcolor="#dddddd" class="title_black" colspan=4>Ìí¼ÓÐÅÏ¢</td></tr>
<tr align="left">
<td width="20%">ÊÖ»úÆ·ÅÆ:</td>
<td width="30%"><SELECT id=firstChoice name=firstChoice onchange="selectChange(this, myChoices.secondChoice, arrItems1, arrItemsGrp1);"><option value=0>ÇëÑ¡ÔñÊÖ»úÆ·ÅÆ</option><?
mobile_sort_list();
?></select></td>
<td width="20%">ÊÖ»úÐͺÅ:</td>
<td width="30%"><SELECT id=secondChoice name=secondChoice>
</SELECT>
</form>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货