01.<?php
02. include_once('ConnectDB.php');
03. conndb();
04.
05.?>
06.<body>
07.<form method="post" action="t2.php">
08.เลือกจังหวัด : <select name="province" onchange="window.location='?proid='+this.value" >
09. <option value="0">- เลือกจังหวัด -</option>
10. <?php
11. $strSQL = "SELECT * FROM province ORDER BY ProvinceNameT ASC";
12. $objQuery = mysql_query($strSQL);
13. while($objResult = mysql_fetch_array($objQuery))
14. {
15. if($_GET["proid"] == $objResult["ProvinceID"])
16. {
17. $sel="selected";
18. }
19. else
20. {
21. $sel="";
22. }
23. ?>
24. <option value="<?php echo $objResult["ProvinceID"];?>" <?php echo $sel;?>><?php echo $objResult["ProvinceNameT"] ;?> </option>';
25. <?php
26. }
27. ?>
28. </select>
29.
30.
31.เลือกอำเภอ : <select name="amphur" onchange="window.location='?ampid='+this.value" >
32. <option value='0'>- เลือกอำเภอ -</option>
33. <?php
34. if($_GET["proid"] == "0"){
35. $strSQL = "SELECT * FROM city ORDER BY CityNameT ASC";
36. } else { $strSQL = "SELECT * FROM city WHERE ProvinceID ='".$_GET["proid"]."' ORDER BY CityNameT ASC";
37. }
38. $objQuery = mysql_query($strSQL);
39. while($objResult = mysql_fetch_array($objQuery))
40. {
41. if($_GET["ampid"] == $objResult["CityID"])
42. {
43. $sel="selected";
44. }
45. else
46. {
47. $sel="";
48. }
49.
50. ?>
51. <option value="<?php echo $objResult["CityID"];?>" <?php echo $sel;?>><?php echo $objResult["CityNameT"];?></option>
52. <?php
53. }
54. ?>
55. </select>
56.เลือกตำบล : <select name="district">
57. <option value='0'>- เลือกตำบล -</option>
58. <?php
59. if($_GET["ampid"] == "0"){
60. $strSQL = "SELECT * FROM district ORDER BY DistrictNameT ASC";
61. } else { $strSQL = "SELECT * FROM district WHERE CityID ='".$_GET["ampid"]."' ORDER BY DistrictNameT ASC";
62. }
63. $objQuery = mysql_query($strSQL);
64. while($objResult = mysql_fetch_array($objQuery))
65. {
66.
67. ?>
68. <option value="<?php echo $objResult["DistrictID"];?> "><?php echo $objResult["DistrictNameT"];?></option>
69. <?php
70. }
71. ?>
72. </select>
73.
74.
Quote:
