01.
<?php
02.
header(
"content-type: text/html; charset=utf-8"
);
03.
header (
"Expires: Wed, 21 Aug 2013 13:13:13 GMT"
);
04.
header (
"Last-Modified: "
.
gmdate
(
"D, d M Y H:i:s"
) .
" GMT"
);
05.
header (
"Cache-Control: no-cache, must-revalidate"
);
06.
header (
"Pragma: no-cache"
);
07.
08.
include
"config.php"
;
09.
conndb();
10.
11.
$data
=
$_GET
[
'data'
];
12.
$val
=
$_GET
[
'val'
];
13.
14.
15.
if
(
$data
==
'province'
) {
16.
echo
"<select name='province' onChange=\"dochange('amphur', this.value)\">"
;
17.
echo
"<option value='0'>- เลือกจังหวัด -</option>\n"
;
18.
$result
=mysql_query(
"select * from province order by PROVINCE_NAME"
);
19.
while
(
$row
= mysql_fetch_array(
$result
)){
20.
echo
"<option value='$row[PROVINCE_ID]' >$row[PROVINCE_NAME]</option>"
;
21.
}
22.
}
else
if
(
$data
==
'amphur'
) {
23.
echo
"<select name='amphur' onChange=\"dochange('district', this.value)\">"
;
24.
echo
"<option value='0'>- เลือกอำเภอ -</option>\n"
;
25.
$result
=mysql_query(
"SELECT * FROM amphur WHERE PROVINCE_ID= '$val' ORDER BY AMPHUR_NAME"
);
26.
while
(
$row
= mysql_fetch_array(
$result
)){
27.
echo
"<option value=\"$row[AMPHUR_ID]\" >$row[AMPHUR_NAME]</option> "
;
28.
}
29.
}
else
if
(
$data
==
'district'
) {
30.
echo
"<select name='district'>\n"
;
31.
echo
"<option value='0'>- เลือกตำบล -</option>\n"
;
32.
$result
=mysql_query(
"SELECT * FROM district WHERE AMPHUR_ID= '$val' ORDER BY DISTRICT_NAME"
);
33.
while
(
$row
= mysql_fetch_array(
$result
)){
34.
echo
"<option value=\"$row[DISTRICT_ID]\" >$row[DISTRICT_NAME]</option> \n"
;
35.
}
36.
}
else
if
(
$data
==
'distric'
) {
37.
echo
"<select name='distric'>\n"
;
38.
echo
"<option value='0'>- เลือกรหัสไปรษณีย์ -</option>\n"
;
39.
$result
=mysql_query(
"SELECT DISTRICT_CODE FROM district WHERE AMPHUR_ID= '$val' ORDER BY DISTRICT_NAME"
);
40.
while
(
$row
= mysql_fetch_array(
$result
)){
41.
echo
"<option value=\"$row[DISTRICT_ID]\" >$row[DISTRICT_CODE]</option> \n"
;
42.
}
43.
}
44.
echo
"</select>\n"
;
45.
46.
echo
mysql_error();
47.
closedb();
48.
?>