Three-level linkage menu of provinces and municipalities (with database)-PHP Tutorial-php.cn

"Content-Type" c/span>"text/html; charset=utf - 8" />
< mce:script type="text/javascript">
$conn
=mysql_connect("localhost","root","");//Link database mysql_select_db("novel "
);//Select database mysql_query("set names 'utf8'"
);//Set character set $sql
="select * from province";//Querying the database province table means saving $result
=mysql_query($s ql); //Assign the execution statement to the variable ?>
.options[this.selectedIndex].value)'>
t)){
//Loop query display provincial output data display
echo
" /n"
} ?>
'city'> ;
[php] view plaincopy
2. $provincecode=$_GET['provincecode'];//Receive provincial key value
3. $citycode=$_GET['citycode'];//Receive city key value
4. $conn=mysql _connect("localhost" ,"root","");//Connect to the host
5. mysql_select_db("novel"); //Select database
6. mysql_query("set names 'utf8'"); ""){
7. //if If the passed value is not empty, execute $sql="select * from city where provincecode=$provincecode";//The query city matches the province passed above The fields
8. $result=mysql_query($sql);//Execute SQL query statement
9. Print_r($row); ?>
10. ($row
11. =mysql_fetch_row($result
12. )){//Loop record set?>
13. tion value="">
14. [2]?> ""){ $sql=
15. ; $result=mysql_que ry(
16. );
19. ; } ?>
20. [xhtml] view plaincopy
  1. -- phpMyAdmin SQL Dump
  2. -- version 2.11.2
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generated date: July 11, 2008 00:45
  7. -- Server version: 5.0.27
  8. -- PHP version: 5.2.0
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  12. --
  13. -- Database: `novel`
  14. --
  15. CREATE DATABASE `novel `DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  16. USE `novel`;
  18. ---------------------------- ----------------------------------
  20. --
  21. -- Table Structure of `area`
  22. --
  24. CREATE TABLE IF NOT EXISTS `area` (
  25. `id` int(11) NOT NULL auto _increment,
  26. `code` varchar(6) NOT NULL,
  27. `name` varchar(20) NOT NULL,
  28. `citycode` varchar(6) NOT NULL,
  29. PRIMARY KEY (`id`)
  30. ) ENGINE=MyISAM DEFAULT CHARSET=utf8AUTO_INCREMENT=3145 ;
  32. -- -- Data in the export table `area`
  33. --
  35. INSERT INTO `area` (`id`, `code`, `name`, `citycode`) VALUES
  36. (1, '110101', 'Dongcheng District', '110100'),
  37. (2, '110102', 'Xicheng District', '110100'),
  38. (3, '110103', 'Chongwen District', '110100'),
  39. (4, '110104', 'Xuanwu District', '110100'),
  40. (5, '110105', 'Chaoyang District', '110100' ),
  41. (6, '110106', 'Fengtai District', '110100'),
  42. (7, '110107', 'Shijingshan District', '110100'),
  43. (8 , '110108', 'Haidian District', '110100'),
  44. (9, '110109', 'Mentougou District', '110100'),
  45. (10, '110111', 'Fangshan District ', '110100'),
  46. (11, '110112', 'Tongzhou District', '110100'),
  47. (12, '110113', 'Shunyi District', '110100'),
  48. (13, '110114', 'Changping District', '110100'),
  49. (14, '110115', 'Daxing District', '110100'),
  50. (15, '110 116 ', 'Huairou District', '110100'),
  51. (16, '110117', 'Pinggu District', '110100'),
  52. (17, '110228', 'Miyun County', ' 110200'),
  53. (18, '110229', 'Yanqing County', '110200'),
  54. (19, '120101', 'Heping District', '120100'),
  55. (20, '120102', 'Hedong District', '120100'),
  56. (21, '120103', 'Hexi District', '120100'),
  57. (22, '120104', ' Nankai District', '120100'),
  58. (23, '120105', 'Hebei District', '120100'),
  59. (24, '120106', 'Hongqiao District', '120100' ),
  60. (25, '120107', 'Tanggu District', '120100'),
  61. (26, '120108', 'Hangu District', '120100'),
  62. (27 , '120109', 'Dagang District', '120100'),
  63. (28, '120110', 'Dongli District', '120100'),
  64. (29, '120111', 'Xiqing District', '120100'),
  65. (30, '120112', 'Jinnan District', '120100'),
  66. (31, '120113 ', 'Beichen District', '120100'),
  67. (32, '120114', 'Wuqing District', '120100'),
  68. (33, '120115', 'Baodi District', '120100'),
  69. (34, '120221', 'Ninghe County', '120200'),
  70. (35, '120223', 'Jinghai County', '120200'),
  71. (36, '120225', 'Ji County', '120200'),
  72. (37, '130101', 'Municipal District', '130100'),
  73. (38, '130102', 'Chang'an District', '130100'),
  74. (39, '130103', 'Qiaodong District', '130100'),
  75. (40, '130104', 'Qiaoxi District', '130100 '),
  76. (41, '130105', 'Xinhua District', '130100'),
  77. (42, '130107', 'Jingxing Mining Area', '130100'),
  78. ( 43, '130108', 'Yuhua District', '130100'),
  79. (44, '130121', 'Jingxian County', '130100'),
  80. (45, '130123', ' Zhengding County', '130100'),
  81. (46, '130124', 'Luancheng County', '130100'),
  82. (47, '130125', 'Xingtang County', '130100 '),
  83. (48, '130126', 'Lingshou County', '130100'),
  84. (49, '130127', 'Gaoyi County', '130100'),
  85. (50, '130128', 'Shenze County', '130100'),
  86. (51, '130129', 'Zanhuang County', '130100'),
  87. (52, '130130 ', 'Wuji County', '130100'),
  88. (53, '130131', 'Pingshan County', '130100'),
  89. (54, '130132', 'Yuanshi County', '130100'),
  90. (55, '130133', 'Zhaoxian', '130100'),
  91. (56, '130181', 'Xinjishi', '130100'),
  92. (57, '130182', 'Gaocheng City', '130100'),
  93. (58, '130183', 'Jinzhou City', '130100'),
  94. (59, '130184' , 'Xinle City', '130100'),
  95. (60, '130185', 'Luquan City', '130100'),
  96. (61, '130201', 'Municipal District', '130200'),
  97. (62, '130202', 'Lunan District', '130200'),
  98. (63, '130203', 'Lubei District', '130200'),
  99. (64, '130204', 'Guye District', '130200'),
  100. (65, '130205', 'Kaiping District', '130200'),
  101. (66, ' 130207', 'Fengnan District', '130200'),
  102. (67, '130208', 'Fengrun District', '130200'),
  103. (68, '130223', 'Luan County' , '130200'),
  104. (69, '130224', 'Luannan County', '130200'),
  105. (70, '130225', 'Leting County', '130200'),
  106. (71, '130227', 'Qianxi County', '130200'),
  107. (72, '130229', 'Yutian County', '130200'),
  108. (73, '130230', 'Tanghai County', '130200'),
  109. (74, '130281', 'Zunhua City', '130200'),
  110. (75, '130283', 'Move Anshi', '130200'),
  111. (76, '130301', 'Municipal District', '130300'),
  112. (77, '130302', 'Haigang District', '130300') ,
  113. (78, '130303', 'Shanhaiguan District', '130300'),
  114. (79, '130304', 'Beidaihe District', '130300'),
  115. ( 80, '130321', 'Qinglong Manchu Autonomous County', '130300'),
  116. (81, '130322', 'Changli County', '130300'),
  117. (82, '130323', 'Funing County ', '130300'),
  118. (83, '130324', 'Lulong County', '130300'),
  119. (84, '130401', 'Municipal District', '130400'),
  120. (85, '130402', 'Hanshan District', '130400'),
  121. (86, '130403', 'Congtai District', '130400'),
  122. (87, '130404', 'Fuxing District', '130400'),
  123. (88, '130406 ', 'Fengfeng Mining Area', '130400'),
  124. (89, '130421', 'Handan County', '130400'),
  125. (90, '130423', 'Linzhang County' , '130400'),
  126. (91, '130424', 'Cheng'an County', '130400'),
  127. (92, '130425', 'Daming County', '130400'),
  128. (93, '130426', 'Shexian', '130400'),
  129. (94, '130427', 'Cixian', '130400'),
  130. (95, '130428' ' 130400'),
  131. (98, '130431', 'Jize County', '130400'),
  132. (99, '130432', 'Guangping County', '130400'),
  133. (100, '130433', 'Guantao County', '130400'),
  134. (101, '130434', 'Wei County', '130400'),
  135. (102, '130435 ', 'Quzhou County', '130400'),
  136. (103, '130481', 'Wu'an City', '130400'),
  137. (104, '130501', 'Municipal District', '130500'),
  138. (105, '130502', 'Qiaodong District', '130500'),
  139. (106, '130503', 'Qiaoxi District', '130500'),
  140. (107, '130521', 'Xingtai County', '130500'),
  141. (108, '130522', 'Lincheng County', '130500'),
  142. (109, '13 0523 ', 'Neiqiu County', '130500'),
  143. (110, '130524', 'Baixiang County', '130500'),
  144. (111, '130525', 'Longyao County ', '130500'),
  145. (112, '130526', 'Ren County', '130500'),
  146. (113, '130527', 'Nanhe County', '130500'),
  147. (114, '130528', 'Ningjin County', '130500'),
  148. (115, '130529', 'Julu County', '130500'),
  149. (116 , '130530', 'Xinhe County', '130500'),
  150. (117, '130531', 'Guangzong County', '130500'),
  151. (118, '130532', ' Pingxiang County', '130500'),
  152. (119, '130533', 'Wei County', '130500'),
  153. (120, '130534', 'Qinghe County', '130500' ),
  154. (121, '130535', 'Linxi County', '130500'),
  155. (122, '130581', 'Nangong City', '130500'),
  156. ( 123, '130582', 'Shahe City', '130500'),
  157. (124, '130601', 'Municipal District', '130600'),
  158. (125, '130602', 'New Urban area', '130600'),
  159. (126, '130603', 'Northern urban area', '130600'),
  160. (127, '130604', 'Southern urban area', '130600' ),
  161. (128, '130621', 'Mancheng County', '130600'),
  162. (129, '130622', 'Qingyuan County', '130600'),
  163. (130, '130623', 'Laishui County', '130600'),
  164. (131, '130624', 'Fuping County', '130600'),
  165. (132, '130625' , 'Xushui County', '130600'),
  166. (133, '130626', 'Dingxing County', '130600'),
  167. (134, '130627', 'Tang County', '130600'),
  168. (135, '130628', 'Gaoyang County', '130600'),
  169. (136, '130629', 'Rongcheng County', '130600'),
  170. (137, '130630', 'Laiyuan County', '130600'),
  171. (138, '130631', 'Wangdu County', '130600'),
  172. (139, '13 0632 ', 'Anxin County', '130600'),
  173. (140, '130633', 'Yixian', '130600'),
  174. (141, '130634', 'Quyang County', '130600'),
  175. (142, '130635', 'Li County', '130600'),
  176. (143, '130636', 'Shunping County', '130600'),
  177. (144, '1306 37 ', 'Boye County', '130600'),
  178. (145, '130638', 'Xiong County', '130600'),
  179. (146, '130681', 'Zhuozhou City', '130600'),
  180. (147, '130682', 'Dingzhou City', '130600'),
  181. (148, '130683', 'Anguo City', '130600'),
  182. (149, '130684', 'Gaobeidian City', '130600'),
  183. (150, '130701', 'Municipal District', '130700'),
  184. (151, ' 130702', 'Qiaodong District', '130700'),
  185. (152, '130703', 'Qiaoxi District', '130700'),
  186. (153, '130705', 'Xuanhua District' , '130700'),
  187. (154, '130706', 'Xiahuayuan District', '130700'),
  188. (155, '130721', 'Xuanhua County', '130700'),
  189. (156, '130722', 'Zhangbei County', '130700'),
  190. (157, '130723', 'Kangbao County', '130700'),
  191. (158, '130724', 'Guyuan County', '130700'),
  192. (159, '130725', 'Shangyi County', '130700'),
  193. (160, '130726', 'Wei County', '130700'),
  194. (161, '130727', 'Yangyuan County', '130700'),
  195. (162, '130728', 'Huai'an County', '130700') ,
  196. (163, '130729', 'Wanquan County', '130700'),
  197. (164, '130730', 'Huailai County', '130700'),
  198. (165 , '130731', 'Zhuolu County', '130700'),
  199. (166, '130732', 'Chicheng County', '130700'),
  200. (167, '130733', 'Chong Li County', '130700'),
  201. (168, '130801', 'Municipal District', '130800'),
  202. (169, '130802', 'Shuangqiao District', '130800' ),
  203. (170, '130803', 'Shuangluan District', '130800'),
  204. (171, '130804', 'Yingshouyingzi Mining District', '130800'),
  205. (172, '130821', 'Chengde County', '130800'),
  206. (173, '130822', 'Xinglong County', '130800'),
  207. (174, '13082 3' , 'Pingquan County', '130800'),
  208. (175, '130824', 'Luanping County', '130800'),
  209. (176, '130825', 'Longhua County', '130800'),
  210. (177, '130826', 'Fengning Manchu Autonomous County', '130800'),
  211. (178, '130827', 'Kancheng Manchu Autonomous County', '130800') ,
  212. (179, '130828', 'Weichang Manchu and Mongolian Autonomous County', '130800'),
  213. (180, '130901', 'Municipal District', '130900'),
  214. (181, '130902', 'Xinhua District', '130900'),
  215. (182, '130903', 'Canal District', '130900'),
  216. (183, '130921', ' Cangxian', '130900'),
  217. (184, '130922', 'Qingxian', '130900'),
  218. (185, '130923', 'Dongguang County', '130900' ),
  219. (186, '130924', 'Haixing County', '130900'),
  220. (187, '130925', 'Yanshan County', '130900'),
  221. (188, '130926', 'Suning County', '130900'),
  222. (189, '130927', 'Nanpi County', '130900'),
  223. (190, '130928', 'Wuqiao County', '130900'),
  224. (191, '130929', 'Xianxian County', '130900'),
  225. (192, '130930', 'Mengcun Hui Autonomous County', ' 130900'),
  226. (193, '130981', 'Botou City', '130900'),
  227. (194, '130982', 'Renqiu City', '130900'),
  228. (195, '130983', 'Huanghua City', '130900'),
  229. (196, '130984', 'Hejian City', '130900'),
  230. (197, '13 1001 ', 'municipal district', '131000'),
  231. (198, '131002', 'Anci District', '131000'),
  232. (199, '131003', 'Guangyang District', '131000'),
  233. (200, ' 131022', 'Gu'an County', '131000'),
  234. (201, '131023', 'Yongqing County', '131000'),
  235. (202, '131024', 'Xianghe County' , '131000'),
  236. (203, '131025', 'Dacheng County', '131000'),
  237. (204, '131026', 'Wen'an County', '131000'),
  238. (205, '131028', 'Dachang Hui Autonomous County', '131000'),
  239. (206, '131081', 'Bazhou City', '131000'),
  240. (207, '131082', 'Sanhe City', '131000'),
  241. (208, '131101', 'Municipal District', '131100'),
  242. (209, '131102', 'Taocheng District' , '131100'),
  243. (210, '131121', 'Zaoqiang County', '131100'),
  244. (211, '131122', 'Wuyi County', '131100'),
  245. (212, '131123', 'Wuqiang County', '131100'),
  246. (213, '131124', 'Raoyang County', '131100'),
  247. (214 , '131125', 'Anping County', '131100'),
  248. (215, '131126', 'Gucheng County', '131100'),
  249. (216, '131127', 'Jing County', '131100'),
  250. (217, '131128', 'Fucheng County', '131100'),
  251. (218, '131181', 'Jizhou City', '131100') ,
  252. (219, '131182', 'Shenzhou City', '131100'),
  253. (220, '140101', 'Municipal District', '140100'),
  254. (221 , '140105', 'Xiaodian District', '140100'),
  255. (222, '140106', 'Yingze District', '140100'),
  256. (223, '140107', ' Xinghualing District', '140100'),
  257. (224, '140108', 'Jiancaoping District', '140100'),
  258. (225, '140109', 'Wanbailin District', '140100'),
  259. (226, '140110', 'Jinyuan District', '140100'),
  260. (227, '140121', 'Qingxu County', '140100'),
  261. (228, '140122', 'Yangqu County', '140100'),
  262. (229, '140123', 'Lofan County', '140100'),
  263. (230, '140181', 'Gujiao City', '140100'),
  264. (231, '140201', 'Municipal District', '140200'),
  265. (232, '140202', 'Urban District' , '140200'),
  266. (233, '140203', 'Mining area', '140200'),
  267. (234, '140211', 'Southern suburbs', '140200'),
  268. (235, '140212', 'Xinrong District', '140200'),
  269. (236, '140221', 'Yanggao County', '140200'),
  270. (237, '140222 ', 'Tianzhen County', '140200'),
  271. (238, '140223', 'Guangling County', '140200'),
  272. (239, '140224', 'Lingqiu County ', '140200'),
  273. (240, '140225', 'Hunyuan County', '140200'),
  274. (241, '140226', 'Zuoyun County', '140200') ,
  275. (242, '140227', 'Datong County', '140200'),
  276. (243, '140301', 'Municipal District', '140300'),
  277. (244, '140302', 'Urban area', '140300'),
  278. (245, '140303', 'Mining area', '140300'),
  279. (246, '140311', 'Suburban', '140300 '),
  280. (247, '140321', 'Pingding County', '140300'),
  281. (248, '140322', 'Yuxian', '140300'),
  282. ( 249, '140401', 'municipal district', '140400'),
  283. (250, '140402', 'urban area', '140400'),
  284. (251, '140411', 'suburban' , '140400'),
  285. (252, '140421', 'Changzhi County', '140400'),
  286. (253, '140423', 'Xiangyuan County', '140400'),
  287. (254, '140424', 'Tunliu County', '140400'),
  288. (255, '140425', 'Pingshun County', '140400'),
  289. (256, '14 0426 ', 'Licheng County', '140400'),
  290. (257, '140427', 'Huguan County', '140400'),
  291. (258, '140428', 'Changzi County' , '140400'),
  292. (259, '140429', 'Wuxiang County', '140400'),
  293. (260, '140430', 'Qin County', '140400'),
  294. (261, '140431', 'Qinyuan County', '140400'),
  295. (262, '140481', 'Lucheng City', '140400'),
  296. (263 , ' 140501', 'Municipal District', '140500'),
  297. (264, '140502', 'Urban District', '140500'),
  298. (265, '140521', 'Qinshui County', '140500'),
  299. (266, '140522', 'Yangcheng County', '140500'),
  300. (267, '140524', 'Lingchuan County', '140500'),
  301. (268, '140525', 'Zezhou County', '140500'),
  302. (269, '140581', 'Gaoping City', '140500'),
  303. (270, ' 140601', 'municipal district', '140600'),
  304. (271, '140602', 'Shocheng District', '140600'),
  305. (272, '140603', 'Pinglu District' , '140600'),
  306. (273, '140621', 'Shanyin County', '140600'),
  307. (274, '140622', 'Ying County', '140600'),
  308. (275, '140623', 'Youyu County', '140600'),
  309. (276, '140624', 'Huairen County', '140600'),
  310. (277, '140701', 'Municipal District', '140700'),
  311. (278, '140702', 'Yuci District', '140700'),
  312. (279, '140721', 'Yulshe County', '140700'),
  313. (280, '140722', 'Zuoquan County', '140700'),
  314. (281, '140723', 'Heshun County', '140700'),
  315. (282, '140724', 'Xiyang County', '140700'),
  316. (283, '140725', 'Shouyang County', '140700'),
  317. (284 , '140726', 'Taigu County', '140700'),
  318. (285, '140727', 'Qixian', '140700'),
  319. (286, '140728', 'Pingyao County', '140700'),
  320. (287, '140729', 'Lingshi County', '140700'),
  321. (288, '140781', 'Jiexiu City', '140700') ,
  322. (289, '140801', 'Municipal District', '140800'),
  323. (290, '140802', 'Salt Lake District', '140800'),
  324. (291, '140821', 'Linyi County', '140800'),
  325. (292, '140822', 'Wanrong County', '140800'),
  326. (293, '140823', 'Wenxi County', '140800'),
  327. (294, '140824', 'Jishan County', '140800'),
  328. (295, '140825', 'Xinjiang County', '140800' ),
  329. (296, '140826', 'Jiang County', '140800'),
  330. (297, '140827', 'Yuanqu County', '140800'),
  331. ( 298, '140828', 'Xia County', '140800'),
  332. (299, '140829', 'Pinglu County', '140800'),
  333. (300, '140830', ' Ruicheng County', '140800'),
  334. (301, '140881', 'Yongji City', '140800'),
  335. (302, '140882', 'Hejin City', '140800 '),
  336. (303, '140901', 'Municipal District', '140900'),
  337. (304, '140902', '忻区', '140900'),
  338. (305, '140921', 'Dingxiang County', '140900'),
  339. (306, '140922', 'Wutai County', '140900'),
  340. (307, '140923' , 'Dai County', '140900'),
  341. (308, '140924', 'Fanzhi County', '140900'),
  342. (309, '140925', 'Ningwu County', '140900'),
  343. (310, '140926', 'Jingle County', '140900'),
  344. (311, '140927', 'Shenchi County', '140900'),
  345. (312, '1409 28 ', 'Wuzhai County', '140900'),
  346. (313, '140929', 'Cairan County', '140900'),
  347. (314, '140930', 'Hequ County' , '140900'),
  348. (315, '140931', 'Baode County', '140900'),
  349. (316, '140932', 'Pianguan County', '140900'),
  350. (317, '140981', 'Yuanping City', '140900'),
  351. (318, '141001', 'Municipal District', '141000'),
  352. (31 9, ' 141002', 'Yaodu District', '141000'),
  353. (320, '141021', 'Quwo County', '141000'),
  354. (321, '141022', 'Yicheng County', '141000'),
  355. (322, '141023', 'Xiangfen County', '141000'),
  356. (323, '141024', 'Hongdong County', '141000' ),
  357. (324, '141025', 'Gu County', '141000'),
  358. (325, '141026', 'Anze County', '141000'),
  359. ( 326, '141027', 'Fushan County', '141000'),
  360. (327, '141028', 'Ji County', '141000'),
  361. (328, '141029', 'Township Ning County', '141000'),
  362. (329, '141030', 'Daning County', '141000'),
  363. (330, '141031', '隰 County', '141000'),
  364. (331, '141032', 'Yonghe County', '141000'),
  365. (332, '141033', 'Puxian County', '141000'),
  366. (333 , ' 141034', 'Fenxi County', '141000'),
  367. (334, '141081', 'Houma City', '141000'),
  368. (335, '141082', 'Huozhou City', '141000'),
  369. (336, '141101', 'Municipal District', '141100'),
  370. (337, '141102', 'Lishi District', '141100') ,
  371. (338, '141121', 'Wenshui County', '141100'),
  372. (339, '141122', 'Jiaocheng County', '141100'),
  373. ( 340, '141123', 'Xingxian', '141100'),
  374. (341, '141124', 'Linxian', '141100'),
  375. (342, '141125', 'Liu Lin County', '141100'),
  376. (343, '141126', 'Shilou County', '141100'),
  377. (344, '141127', 'Lan County', '141100' ),
  378. (345, '141128', 'Fangshan County', '141100'),
  379. (346, '141129', 'Zhongyang County', '141100'),
  380. (347, '141130', 'Jiaokou County', '141100'),
  381. (348, '141181', 'Xiaoyi City', '141100'),
  382. (349, '141182', 'fenyang city', '141100'),
  383. (350, '150101', 'municipal district', '150100'),
  384. (351, '150102', 'new city area', '150100 '),
  385. (352, '150103', 'Huimin District', '150100'),
  386. (353, '150104', 'Yuquan District', '150100'),
  387. ( 354, '150105', 'Saihan District', '150100'),
  388. (355, '150121', 'Tumut Left Banner', '150100'),
  389. (356, '150122 ', 'Toketuo County', '150100'),
  390. (357, '150123', 'Helinger County', '150100'),
  391. (358, '150124', ' Qingshuihe County', '150100'),
  392. (359, '150125', 'Wuchuan County', '150100'),
  393. (360, '150201', 'Municipal District', '150200' ),
  394. (361, '150202', 'Donghe District', '150200'),
  395. (362, '150203', 'Kundulun District', '150200'),
  396. (363, '150204', '青山山', '150200'),
  397. (364, '150205', 'Shiguai District', '150200'),
  398. (365, '150206' , 'Baiyun Mining Area', '150200'),
  399. (366, '150207', 'Jiuyuan District', '150200'),
  400. (367, '150221', 'Tumut Right Banner', '150200'),
  401. (368 , '150222', 'Guyang County', '150200'),
  402. (369, '150223', 'Darkhan Maoming'an United Banner', '150200'),
  403. (370, '150301 ', 'Municipal district', '150300'),
  404. (371, '150302', 'Haibowan District', '150300'),
  405. (372, '150303', 'Hainan District' , '150300'),
  406. (373, '150304', 'Wuda District', '150300'),
  407. (374, '150401', 'Municipal District', '150400'),
  408. (375, '150402', 'Hongshan District', '150400'),
  409. (376, '150403', 'Yuanbaoshan District', '150400'),
  410. (377, '1 50404 ', 'Songshan District', '150400'),
  411. (378, '150421', 'Aruhorqin Banner', '150400'),
  412. (379, '150422', 'Bahrain Left Banner ', '150400'),
  413. (380, '150423', 'Bahrain Right Banner', '150400'),
  414. (381, '150424', 'Linxi County', '150400') ,
  415. (382, '150425', 'Keshiketeng Banner', '150400'),
  416. (383, '150426', 'Wengniute Banner', '150400'),
  417. (384, '150428', 'Kalaqin Banner', '150400'),
  418. (385, '150429', 'Ningcheng County', '150400'),
  419. (386, '150430', 'Aohan Banner', '150400'),
  420. (387, '150501', 'Municipal District', '150500'),
  421. (388, '150502', 'Horqin District ', '150500'),
  422. (389, '150521', 'Horqin left-wing center flag', '150500'),
  423. (390, '150522', 'Horqin left-wing rear flag', '150500 '),
  424. (391, '150523', 'Kailu County', '150500'),
  425. (392, '150524', 'Kulun Banner', '150500'),
  426. (393, '150525', 'Naiman Flag', '150500'),
  427. (394, '150526', 'Zalut Flag', '150500'),
  428. (395, '150581', ' Holingol City', '150500'),
  429. (396, '150602', 'Dongsheng District', '150600'),
  430. (397, '150621', 'Dalat Banner ', '150600'),
  431. (398, '150622', 'Zhungar Banner', '150600'),
  432. (399, '150623', 'Etuoke Front Banner', ' 150600'),
  433. (400, '150624', 'Etok Banner', '150600'),
  434. (401, '150625', 'Hangjin Banner', '150600'),
  435. (402, '150626', 'Wushen Banner', '150600'),
  436. (403, '150627', 'Ejinholo Banner', '150600'),
  437. (404 , '150701', 'Municipal District', '150700'),
  438. (405, '150702', 'Hailaer District', '150700'),
  439. (406, '150721', 'Arong Banner' , '150700'),
  440. (407, '150722', 'Moli Dawa Daur Autonomous Banner', '150700'),
  441. (408, '150723', 'Oroqen Autonomous Banner', '150700'),
  442. (409, '150724', 'Evenki Autonomous Banner', '150700'),
  443. (410, '150725', 'Chenbalhu Banner', '150700') ,
  444. (411, '150726', 'New Barhu Left Banner', '150700'),
  445. (412, '150727', 'New Barhu Right Banner', '150700'),
  446. (413, '150781', 'Manzhouli City', '150700'),
  447. (414, '150782', 'Yakeshi City', '150700'),
  448. (415, '150783', 'Zhalantun City', '150700'),
  449. (416, '150784', 'Ergun City', '150700'),
  450. (417, '150785' , 'Genhe City', '150700'),
  451. (418, '150801', 'Municipal District', '150800'),
  452. (419, '150802', 'Linhe District', ' 150800'),
  453. (420, '150821', 'Wuyuan County', '150800'),
  454. (421, '150822', 'Dengkou County', '150800'),
  455. (422, ' 150823', 'Urad Front Banner', '150800'),
  456. (423, '150824', 'Urad Middle Banner', '150800'),
  457. (424, '150825', ' Urad Houqi', '150800'),
  458. (425, '150826', 'Hangjin Houqi', '150800'),
  459. (426, '150901', 'Municipal District', '150900' ),
  460. (427, '150902', 'Jining District', '150900'),
  461. (428, '150921', 'Zhuozi County', '150900'),
  462. (429, '150922', 'Huade County', '150900'),
  463. (430, '150923', 'Shangdu County', '150900'),
  464. (431, '150924', 'Xinghe County', '150900'),
  465. (432, '150925', 'Liangcheng County', '150900'),
  466. (433, '150926', 'Chahar right wing front Flag', '150900'),
  467. (434, '150927', 'Chahar Right Center Flag', '150900'),
  468. (435, '150928', 'Chahar Right Back flag', '150900'),
  469. (436, '150929', 'Siziwang Banner', '150900'),
  470. (437, '150981', 'Fengzhen City', '150900'),
  471. (438, '152201', 'Ulanhot City', '152200'),
  472. (439, '152202', 'Aershan City', '152200'),
  473. (4 40, '152221', 'Horqin right front flag', '152200'),
  474. (441, '152222', 'Horqin right middle flag', '152200'),
  475. (442, '152223', 'Zhalaite Banner', '152200'),
  476. (443, '152224', 'Tuquan County', '152200'),
  477. (444, '152501', 'Erenhot City', '152500'),
  478. (445, '152502', 'Xilinhot City', '152500'),
  479. (446, '152522', 'Abaga Banner', '152500'),
  480. (447, '152523', 'Sunit Left Flag', '152500'),
  481. (448, '152524', 'Sunit Right Flag', '152500'),
  482. (449, '152525', 'East Ujimqin Banner', '152500'),
  483. (450, '152526', 'West Ujimqin Banner', '152500'),
  484. (451, '152527', 'Taipusi flag', '152500'),
  485. (452, '152528', 'Xianhuang flag', '152500'),
  486. (453, '152529' , ' Zhengbaiqi', '152500'),
  487. (454, '152530', 'Zhenglanqi', '152500'),
  488. (455, '152531', 'Duolun County', ' 152500'),
  489. (456, '152921', 'Alxa Left Banner', '152900'),
  490. (457, '152922', 'Alxa Right Banner', '152900'),
  491. (458, '152923', 'Ejina Banner', '152900'),
  492. (459, '210101', 'Municipal District', '210100'),
  493. (4 60, ' 210102', 'Heping District', '210100'),
  494. (461, '210103', 'Chenhe District', '210100'),
  495. (462, '210104', 'Dadong District', '210100'),
  496. (463, '210105', 'Huanggu District', '210100'),
  497. (464, '210106', 'Tiexi District', '210100'),
  498. (465, '210111', 'Sujiatun District', '210100'),
  499. (466, '210112', 'Donngling District', '210100'),
  500. (467 , '210113', 'Xinchengzi District', '210100'),
  501. (468, '210114', 'Yuhong District', '210100'),
  502. (469, '210122', ' Liaozhong County', '210100'),
  503. (470, '210123', 'Kangping County', '210100'),
  504. (471, '210124', 'Faku County', '210100 '),
  505. (472, '210181', 'Xinmin City', '210100'),
  506. (473, '210201', 'Municipal District', '210200'),
  507. (474, '210202', 'Zhongshan District', '210200'),
  508. (475, '210203', 'Xigang District', '210200'),
  509. (476, '210204 ', 'Shahekou District', '210200'),
  510. (477, '210211', 'Ganjingzi District', '210200'),
  511. (478, '210212', 'Lvshunkou District' , '210200'),
  512. (479, '210213', 'Jinzhou District', '210200'),
  513. (480, '210224', 'Changhai County', '210200'),
  514. (481, '210281', 'Wafangdian City', '210200'),
  515. (482, '210282', 'Pulandian City', '210200'),
  516. (483 , '210283', 'Zhuanghe City', '210200'),
  517. (484, '210301', 'Municipal District', '210300'),
  518. (485, '210302', 'Iron East District', '210300'),
  519. (486, '210303', 'Tiexi District', '210300'),
  520. (487, '210304', 'Lishan District', '210300') ,
  521. (488, '210311', 'Qianshan District', '210300'),
  522. (489, '210321', 'Taian County', '210300'),
  523. ( 490, '210323', 'Xiuyan Manchu Autonomous County', '210300'),
  524. (491, '210381', 'Haicheng City', '210300'),
  525. (492, '210401', 'City Jurisdiction', '210400'),
  526. (493, '210402', 'Xinfu District', '210400'),
  527. (494, '210403', 'Dongzhou District', '210400' ),
  528. (495, '210404', 'Wanghua District', '210400'),
  529. (496, '210411', 'Shuncheng District', '210400'),
  530. (497 , '210421', 'Fushun County', '210400'),
  531. (498, '210422', 'Xinbin Manchu Autonomous County', '210400'),
  532. (499, '210423', ' Qingyuan Manchu Autonomous County', '210400'),
  533. (500, '210501', 'Municipal District', '210500'),
  534. (501, '210502', 'Pingshan District', '210500' ),
  535. (502, '210503', 'Xihu District', '210500'),
  536. (503, '210504', 'Mingshan District', '210500'),
  537. ( 504 , '210505', 'Nanfen District', '210500'),
  538. (505, '210521', 'Benxi Manchu Autonomous County', '210500'),
  539. (506, '210522', ' Huanren Manchu Autonomous County', '210500'),
  540. (507, '210601', 'Municipal District', '210600'),
  541. (508, '210602', 'Yuanbao District', '210600 '),
  542. (509, '210603', 'Zhenxing District', '210600'),
  543. (510, '210604', 'Zhen'an District', '210600'),
  544. ( 511, '210624', 'Kandian Manchu Autonomous County', '210600'),
  545. (512, '210681', 'Donggang City', '210600'),
  546. (513, '210682', 'Fengcheng City', '210600'),
  547. (514, '210701', 'Municipal District', '210700'),
  548. (515, '210702', 'Guta District', '210700 '),
  549. (516, '210703', 'Linghe District', '210700'),
  550. (517, '210711', 'Taihe District', '210700'),
  551. (518, '210726', 'Heishan County', '210700'),
  552. (519, '210727', 'Yixian', '210700'),
  553. (520, '210781', 'Linghai City', '210700'),
  554. (521, '210782', 'Beining City', '210700'),
  555. (522, '210801', 'Municipal District', '210800 '),
  556. (523, '210802', 'Zhanqian District', '210800'),
  557. (524, '210803', 'Western City District', '210800'),
  558. (525, '210804', 'Bayuquan District', '210800'),
  559. (526, '210811', 'Old Border District', '210800'),
  560. (527, '210881 ', 'Gaizhou City', '210800'),