001.<?php
002.
003.
004.
005. $objConnect = mysql_connect("localhost","root","123456") or die("Error Connect to Database");
006. $objDB = mysql_select_db("floodthaicodi");
007. @mysql_query("SET NAMES UTF8");
008.?>
009.<html>
010.<head>
011.<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
012.<title>ThaiCreate.Com ListMenu</title>
013.<script language = "JavaScript">
014.
015.
016. function ListProvince(SelectValue)
017. {
018. frmMain.ddlProvince.length = 0
019. frmMain.ddlAmphur.length = 0
020.
021. var myOption = new Option('','')
022. frmMain.ddlProvince.options[frmMain.ddlProvince.length]= myOption
023.
024. <?
025. $intRows = 0;
026. $strSQL = "SELECT * FROM province ORDER BY PROVINCE_ID ASC ";
027. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
028. $intRows = 0;
029. while($objResult = mysql_fetch_array($objQuery))
030. {
031. $intRows++;
032. ?>
033. x = <?=$intRows;?>;
034. mySubList = new Array();
035.
036. strGroup = <?=$objResult["GEO_ID"];?>;
037. strValue = "<?=$objResult["PROVINCE_ID"];?>";
038. strItem = "<?=$objResult["PROVINCE_NAME"];?>";
039. mySubList[x,0] = strItem;
040. mySubList[x,1] = strGroup;
041. mySubList[x,2] = strValue;
042. if (mySubList[x,1] == SelectValue){
043. var myOption = new Option(mySubList[x,0], mySubList[x,2])
044. frmMain.ddlProvince.options[frmMain.ddlProvince.length]= myOption
045. }
046. <?
047. }
048. ?>
049. }
050.
051.
052.
053.
054. function ListAmphur(SelectValue)
055. {
056. frmMain.ddlAmphur.length = 0
057. frmMain.ddldistrict.length = 0
058.
059. var myOption = new Option('','')
060. frmMain.ddlAmphur.options[frmMain.ddlAmphur.length]= myOption
061.
062. <?
063. $intRows = 0;
064. $strSQL = "SELECT * FROM amphur ORDER BY AMPHUR_ID ASC ";
065. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
066. $intRows = 0;
067. while($objResult = mysql_fetch_array($objQuery))
068. {
069. $intRows++;
070. ?>
071. x = <?=$intRows;?>;
072. mySubList = new Array();
073.
074. strGroup = <?=$objResult["PROVINCE_ID"];?>;
075. strValue = "<?=$objResult["AMPHUR_ID"];?>";
076. strItem = "<?=$objResult["AMPHUR_NAME"];?>";
077. mySubList[x,0] = strItem;
078. mySubList[x,1] = strGroup;
079. mySubList[x,2] = strValue;
080.
081. if (mySubList[x,1] == SelectValue){
082. var myOption = new Option(mySubList[x,0], mySubList[x,2])
083. frmMain.ddlAmphur.options[frmMain.ddlAmphur.length]= myOption
084. }
085. <?
086. }
087. ?>
088. }
089.
090.
091.
092. function Listdistrict(SelectValue)
093. {
094. frmMain.ddldistrict.length = 0
095.
096.
097. var myOption = new Option('','')
098. frmMain.ddldistrict.options[frmMain.ddldistrict.length]= myOption
099.
100. <?
101. $intRows = 0;
102. $strSQL = "SELECT * FROM district ORDER BY DISTRICT_ID ASC ";
103. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
104. $intRows = 0;
105. while($objResult = mysql_fetch_array($objQuery))
106. {
107. $intRows++;
108. ?>
109. x = <?=$intRows;?>;
110. mySubList = new Array();
111.
112. strGroup = <?=$objResult["AMPHUR_ID"];?>;
113. strValue = "<?=$objResult["DISTRICT_ID"];?>";
114. strItem = "<?=$objResult["DISTRICT_NAME"];?>";
115. mySubList[x,0] = strItem;
116. mySubList[x,1] = strGroup;
117. mySubList[x,2] = strValue;
118.
119. if (mySubList[x,1] == SelectValue){
120. var myOption = new Option(mySubList[x,0], mySubList[x,2])
121. frmMain.ddldistrict.options[frmMain.ddldistrict.length]= myOption
122. }
123. <?
124. }
125. ?>
126. }
127.
128.
129.</script>
130.
131.
132.</head>
133.<form name="frmMain" action="" method="post">
134. Geography
135. <select id="ddlGeo" name="ddlGeo" onChange = "ListProvince(this.value)">
136. <option selected value=""></option>
137. <?
138. $strSQL = "SELECT * FROM geography ORDER BY GEO_ID ASC ";
139. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
140. while($objResult = mysql_fetch_array($objQuery))
141. {
142. ?>
143. <option value="<?=$objResult["GEO_ID"];?>"><?=$objResult["GEO_NAME"];?></option>
144. <?
145. }
146. ?>
147. </select>
148.
149. Province
150. <select id="ddlProvince" name="ddlProvince" style="width:120px" onChange = "ListAmphur(this.value)"></select>
151.
152. Amphur
153. <select id="ddlAmphur" name="ddlAmphur" style="width:200px" onChange = "Listdistrict(this.value)"></select>
154.
155. District
156. <select id="ddldistrict" name="ddldistrict" style="width:200px"></select>
157.
158.</form>
159.</body>
160.</html>
161.<?
162. mysql_close($objConnect);
163.?>
