01.<script language = "JavaScript">
02.
03.
04. function Listspechee(SelectValue)
05. {
06. frmMain.spechee.length = 0
07.
08.
09.
10. var myOption = new Option('','')
11. frmMain.spechee.options[frmMain.spechee.length]= myOption
12.
13. <?
14. $intRows = 0;
15. $strSQL = "SELECT * FROM tb_spechee ORDER BY s_id ASC ";
16. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
17. $intRows = 0;
18. while($objResult = mysql_fetch_array($objQuery))
19. {
20. $intRows++;
21. ?>
22. x = <?=$intRows;?>;
23. mySubList = new Array();
24.
25. strGroup = <?=$objResult["ref_t_id"];?>;
26. strValue = "<?=$objResult["s_id"];?>";
27. strItem = "<?=$objResult["s_name"];?>";
28. mySubList[x,0] = strItem;
29. mySubList[x,1] = strGroup;
30. mySubList[x,2] = strValue;
31. if (mySubList[x,1] == SelectValue){
32. var myOption = new Option(mySubList[x,0], mySubList[x,2])
33. frmMain.spechee.options[frmMain.spechee.length]= myOption
34. }
35. <?
36. }
37. ?>
38. }
39.
40.
41.
42.</script>
