迪厅 ktv 的网站

<? $result_1 = mysql_query("SELECT * FROM $morning_sub_table ORDER BY sub_id"); ?> <script language="javascript"> var onecount; onecount=0; subcat = new Array(); <? $count = 0; while($r = mysql_fetch_array($result_1)){ ?> subcat[<?=$count?>] = new Array("<?= $r["cat_name"]?>","<?= $r["cat_id"]?>","<?= $r["sub_id"]?>"); <? $count++; } morning_free_result($result_1); ?> onecount = <?=$count?>; function changelocation(locationid) { document.myform.sub_id.length = 0; var locationid=locationid; var i; for (i=0;i < onecount; i++) { if (subcat[i][1] == locationid) { document.myform.sub_id.options[document.myform.sub_id.length] = new Option(subcat[i][0], subcat[i][2]); } } } </script> <form name="myform" method="post" action=""> <table width="30%"> <tr> <td>所在类型</td> <td> <select size="1" name="catid" id="catid" onChange="changelocation(document.myform.catid.options[document.myform.catid.selectedIndex].value)"> <option value="">--选择所在类型--</option> <? $result = mysql_query("SELECT * FROM $morning_cat_table"); while($r = mysql_fetch_array($result)){ ?> <option value="<?=$r['cat_id']?>"><?=$r['cat_name']?></option> <? $selclass = $r['cat_id']; } morning_free_result($result); ?> </select></td> </tr> <? } ?> <tr class="firstrow"> <td width="28%">所在栏目</td> <td width="72%"> <select size="1" name="sub_id" > <? if ($mod != 'edit'){ ?> <option value="">--选择所在栏目--</option> <? } ?> <? if (isset($list[sub_id])) { $res = mysql_query("SELECT * FROM $morning_sub_table WHERE sub_id = '$list[sub_id]'"); } else { $res = mysql_query("select * from $morning_sub_table WHERE sub_id = '$selclass'"); } while ($r = mysql_fetch_array($res)) { ?> <option value="<?=$r[sub_id]?>"><?=$r[cat_name]?></option> <? } morning_free_result($res); ?> </select></td> </tr> </table> </form> <!-- ********************** 说明： 表 morning_cat_table是类型表，字段:cat_id(类型id),cat_name(类型名称) 表 morning_sub_table是某个类型下的拦目,字段：sub_id(拦目id),cat_id(所属的类型id),cat_name(栏目名称) ********************** -->