GEO Source Code

The Programmers Community

Skip to content

Pakistan Cities List

This sections will contains code regarding different PHP & MySQL features and contains help about php/mysql issues.
Post a reply

Pakistan Cities List

Postby MT Shahzad on March 21st, 2008, 7:40 pm

Here is the list of Pakistan Cities in SQL format.

Code: Select all

CREATE TABLE tblPakCities
(
  cityId INT NOT NULL AUTO_INCREMENT,
  cityName VARCHAR(50),
 
  PRIMARY KEY (cityId)
);

INSERT INTO tblPakCities VALUES (null, 'Ghanian');
INSERT INTO tblPakCities VALUES (null, 'Ali Bandar');
INSERT INTO tblPakCities VALUES (null, 'Baden');
INSERT INTO tblPakCities VALUES (null, 'Chachro');
INSERT INTO tblPakCities VALUES (null, 'Dadu');
INSERT INTO tblPakCities VALUES (null, 'Digri');
INSERT INTO tblPakCities VALUES (null, 'Diplo');
INSERT INTO tblPakCities VALUES (null, 'Dokri');
INSERT INTO tblPakCities VALUES (null, 'Gadra');
INSERT INTO tblPakCities VALUES (null, 'Ghauspur');
INSERT INTO tblPakCities VALUES (null, 'Ghotki');
INSERT INTO tblPakCities VALUES (null, 'Hala');
INSERT INTO tblPakCities VALUES (null, 'Hyderabad');
INSERT INTO tblPakCities VALUES (null, 'Islamkot');
INSERT INTO tblPakCities VALUES (null, 'Jacobabad');
INSERT INTO tblPakCities VALUES (null, 'Jamesabad');
INSERT INTO tblPakCities VALUES (null, 'Jamshoro');
INSERT INTO tblPakCities VALUES (null, 'Janghar');
INSERT INTO tblPakCities VALUES (null, 'Jati (Mughalbhin)');
INSERT INTO tblPakCities VALUES (null, 'Jhudo');
INSERT INTO tblPakCities VALUES (null, 'Jungshahi');
INSERT INTO tblPakCities VALUES (null, 'Kandiaro');
INSERT INTO tblPakCities VALUES (null, 'Karachi');
INSERT INTO tblPakCities VALUES (null, 'Kashmor');
INSERT INTO tblPakCities VALUES (null, 'Keti Bandar');
INSERT INTO tblPakCities VALUES (null, 'Khairpur');
INSERT INTO tblPakCities VALUES (null, 'Khora');
INSERT INTO tblPakCities VALUES (null, 'Klupro');
INSERT INTO tblPakCities VALUES (null, 'Khokhropur');
INSERT INTO tblPakCities VALUES (null, 'Korangi');
INSERT INTO tblPakCities VALUES (null, 'Kotri');
INSERT INTO tblPakCities VALUES (null, 'Kot Sarae');
INSERT INTO tblPakCities VALUES (null, 'Larkana');
INSERT INTO tblPakCities VALUES (null, 'Lund');
INSERT INTO tblPakCities VALUES (null, 'Mathi');
INSERT INTO tblPakCities VALUES (null, 'Matiari');
INSERT INTO tblPakCities VALUES (null, 'Mehar');
INSERT INTO tblPakCities VALUES (null, 'Mirpur Batoro');
INSERT INTO tblPakCities VALUES (null, 'Mirpur Khas');
INSERT INTO tblPakCities VALUES (null, 'Mirpur Sakro');
INSERT INTO tblPakCities VALUES (null, 'Mithi');
INSERT INTO tblPakCities VALUES (null, 'Moro');
INSERT INTO tblPakCities VALUES (null, 'Nagar Parkar');
INSERT INTO tblPakCities VALUES (null, 'Naushara');
INSERT INTO tblPakCities VALUES (null, 'Nawabshah');
INSERT INTO tblPakCities VALUES (null, 'Nazimabad');
INSERT INTO tblPakCities VALUES (null, 'Naokot');
INSERT INTO tblPakCities VALUES (null, 'Pokran');
INSERT INTO tblPakCities VALUES (null, 'Qambar');
INSERT INTO tblPakCities VALUES (null, 'Qazi Ahmad');
INSERT INTO tblPakCities VALUES (null, 'Ranipur');
INSERT INTO tblPakCities VALUES (null, 'Ratodero');
INSERT INTO tblPakCities VALUES (null, 'Rohri');
INSERT INTO tblPakCities VALUES (null, 'Sakrand');
INSERT INTO tblPakCities VALUES (null, 'Shadadkhot');
INSERT INTO tblPakCities VALUES (null, 'Shahbandar');
INSERT INTO tblPakCities VALUES (null, 'Shahpur Chakar');
INSERT INTO tblPakCities VALUES (null, 'Shikarpur');
INSERT INTO tblPakCities VALUES (null, 'Sujawal');
INSERT INTO tblPakCities VALUES (null, 'Sukkur');
INSERT INTO tblPakCities VALUES (null, 'Tando Adam');
INSERT INTO tblPakCities VALUES (null, 'Tando Bago');
INSERT INTO tblPakCities VALUES (null, 'Tar Ahamd Rind');
INSERT INTO tblPakCities VALUES (null, 'Thatta');
INSERT INTO tblPakCities VALUES (null, 'Tujal');
INSERT INTO tblPakCities VALUES (null, 'Umarkot');
INSERT INTO tblPakCities VALUES (null, 'Veirwaro');
INSERT INTO tblPakCities VALUES (null, 'Pendoo');
INSERT INTO tblPakCities VALUES (null, 'Warah');
INSERT INTO tblPakCities VALUES (null, 'Kamber');
INSERT INTO tblPakCities VALUES (null, 'Attock');
INSERT INTO tblPakCities VALUES (null, 'Bhalwal');
INSERT INTO tblPakCities VALUES (null, 'Bahawalnagar');
INSERT INTO tblPakCities VALUES (null, 'Bahawalpur');
INSERT INTO tblPakCities VALUES (null, 'Bhakkar');
INSERT INTO tblPakCities VALUES (null, 'Burewala');
INSERT INTO tblPakCities VALUES (null, 'Chailianwala');
INSERT INTO tblPakCities VALUES (null, 'Chakwal');
INSERT INTO tblPakCities VALUES (null, 'Chichawatni');
INSERT INTO tblPakCities VALUES (null, 'Chiniot');
INSERT INTO tblPakCities VALUES (null, 'Daska');
INSERT INTO tblPakCities VALUES (null, 'Darya Khan');
INSERT INTO tblPakCities VALUES (null, 'Dera Ghazi Khan');
INSERT INTO tblPakCities VALUES (null, 'Dina');
INSERT INTO tblPakCities VALUES (null, 'Dinga');
INSERT INTO tblPakCities VALUES (null, 'Faisalabad');
INSERT INTO tblPakCities VALUES (null, 'Fateh Jang');
INSERT INTO tblPakCities VALUES (null, 'Ghakhar Mandi');
INSERT INTO tblPakCities VALUES (null, 'Gujranwala');
INSERT INTO tblPakCities VALUES (null, 'Gujrat');
INSERT INTO tblPakCities VALUES (null, 'Hafizabad');
INSERT INTO tblPakCities VALUES (null, 'Hasilpur');
INSERT INTO tblPakCities VALUES (null, 'Haveli Lakha');
INSERT INTO tblPakCities VALUES (null, 'Islamabad');
INSERT INTO tblPakCities VALUES (null, 'Jampur');
INSERT INTO tblPakCities VALUES (null, 'Jhang');
INSERT INTO tblPakCities VALUES (null, 'Jhelum');
INSERT INTO tblPakCities VALUES (null, 'Kasur');
INSERT INTO tblPakCities VALUES (null, 'Kamalia');
INSERT INTO tblPakCities VALUES (null, 'Kamokey');
INSERT INTO tblPakCities VALUES (null, 'Khanewal');
INSERT INTO tblPakCities VALUES (null, 'Khushab');
INSERT INTO tblPakCities VALUES (null, 'Jauharabad');
INSERT INTO tblPakCities VALUES (null, 'Lahore');
INSERT INTO tblPakCities VALUES (null, 'Layyah');
INSERT INTO tblPakCities VALUES (null, 'Leiah');
INSERT INTO tblPakCities VALUES (null, 'Lodhran');
INSERT INTO tblPakCities VALUES (null, 'Mandi Bahauddin');
INSERT INTO tblPakCities VALUES (null, 'Mian Chanu');
INSERT INTO tblPakCities VALUES (null, 'Mianwali');
INSERT INTO tblPakCities VALUES (null, 'Multan');
INSERT INTO tblPakCities VALUES (null, 'Muridke');
INSERT INTO tblPakCities VALUES (null, 'Muzaffar Garh');
INSERT INTO tblPakCities VALUES (null, 'Okara');
INSERT INTO tblPakCities VALUES (null, 'Renala Khurd');
INSERT INTO tblPakCities VALUES (null, 'Rajan Pur');
INSERT INTO tblPakCities VALUES (null, 'Pirmahal');
INSERT INTO tblPakCities VALUES (null, 'Rabwah');
INSERT INTO tblPakCities VALUES (null, 'Rahim Yar Khan');
INSERT INTO tblPakCities VALUES (null, 'Rawalpindi');
INSERT INTO tblPakCities VALUES (null, 'Sadiqabad');
INSERT INTO tblPakCities VALUES (null, 'Safdar Abad - (Dhaban Singh)');
INSERT INTO tblPakCities VALUES (null, 'Sahiwal');
INSERT INTO tblPakCities VALUES (null, 'Sargodha');
INSERT INTO tblPakCities VALUES (null, 'Shakargarh');
INSERT INTO tblPakCities VALUES (null, 'Sheikhupura');
INSERT INTO tblPakCities VALUES (null, 'Sialkot');
INSERT INTO tblPakCities VALUES (null, 'Sohawa');
INSERT INTO tblPakCities VALUES (null, 'Sooianwala');
INSERT INTO tblPakCities VALUES (null, 'Toba Tek Singh');
INSERT INTO tblPakCities VALUES (null, 'Vehari');
INSERT INTO tblPakCities VALUES (null, 'Wah Cantt');
INSERT INTO tblPakCities VALUES (null, 'Wazirabad');
INSERT INTO tblPakCities VALUES (null, 'Kharian');
INSERT INTO tblPakCities VALUES (null, 'Abbottabad');
INSERT INTO tblPakCities VALUES (null, 'Ayubia');
INSERT INTO tblPakCities VALUES (null, 'Adezai');
INSERT INTO tblPakCities VALUES (null, 'Banda Daud Shah');
INSERT INTO tblPakCities VALUES (null, 'Bannu');
INSERT INTO tblPakCities VALUES (null, 'Batagram');
INSERT INTO tblPakCities VALUES (null, 'Birote');
INSERT INTO tblPakCities VALUES (null, 'Buner');
INSERT INTO tblPakCities VALUES (null, 'Chakdara');
INSERT INTO tblPakCities VALUES (null, 'Charsadda');
INSERT INTO tblPakCities VALUES (null, 'Chitral');
INSERT INTO tblPakCities VALUES (null, 'Dargai');
INSERT INTO tblPakCities VALUES (null, 'Darya Khan');
INSERT INTO tblPakCities VALUES (null, 'Dera Ismail Khan');
INSERT INTO tblPakCities VALUES (null, 'Drosh');
INSERT INTO tblPakCities VALUES (null, 'Hangu');
INSERT INTO tblPakCities VALUES (null, 'Haripur');
INSERT INTO tblPakCities VALUES (null, 'Kalam');
INSERT INTO tblPakCities VALUES (null, 'Karak');
INSERT INTO tblPakCities VALUES (null, 'Khanaspur');
INSERT INTO tblPakCities VALUES (null, 'Kohat');
INSERT INTO tblPakCities VALUES (null, 'Kohistan');
INSERT INTO tblPakCities VALUES (null, 'Lakki Marwat');
INSERT INTO tblPakCities VALUES (null, 'Latamber');
INSERT INTO tblPakCities VALUES (null, 'Lower Dir');
INSERT INTO tblPakCities VALUES (null, 'Madyan');
INSERT INTO tblPakCities VALUES (null, 'Malakand');
INSERT INTO tblPakCities VALUES (null, 'Mansehra');
INSERT INTO tblPakCities VALUES (null, 'Mardan');
INSERT INTO tblPakCities VALUES (null, 'Mastuj');
INSERT INTO tblPakCities VALUES (null, 'Mongora');
INSERT INTO tblPakCities VALUES (null, 'Nowshera');
INSERT INTO tblPakCities VALUES (null, 'Paharpur');
INSERT INTO tblPakCities VALUES (null, 'Peshawar');
INSERT INTO tblPakCities VALUES (null, 'Saidu Sharif');
INSERT INTO tblPakCities VALUES (null, 'Shangla');
INSERT INTO tblPakCities VALUES (null, 'Swabi');
INSERT INTO tblPakCities VALUES (null, 'Swat');
INSERT INTO tblPakCities VALUES (null, 'Tangi');
INSERT INTO tblPakCities VALUES (null, 'Tank');
INSERT INTO tblPakCities VALUES (null, 'Tordher');
INSERT INTO tblPakCities VALUES (null, 'Upper Dir');
INSERT INTO tblPakCities VALUES (null, 'Amir Chah');
INSERT INTO tblPakCities VALUES (null, 'Bazdar');
INSERT INTO tblPakCities VALUES (null, 'Bela');
INSERT INTO tblPakCities VALUES (null, 'Bellpat');
INSERT INTO tblPakCities VALUES (null, 'Bagh');
INSERT INTO tblPakCities VALUES (null, 'Burj');
INSERT INTO tblPakCities VALUES (null, 'Chagai');
INSERT INTO tblPakCities VALUES (null, 'Chah Sandan');
INSERT INTO tblPakCities VALUES (null, 'Chakku');
INSERT INTO tblPakCities VALUES (null, 'Chaman');
INSERT INTO tblPakCities VALUES (null, 'Chhatr');
INSERT INTO tblPakCities VALUES (null, 'Dalbandin');
INSERT INTO tblPakCities VALUES (null, 'Dera Bugti');
INSERT INTO tblPakCities VALUES (null, 'Dhana Sar');
INSERT INTO tblPakCities VALUES (null, 'Diwana');
INSERT INTO tblPakCities VALUES (null, 'Duki');
INSERT INTO tblPakCities VALUES (null, 'Dushi');
INSERT INTO tblPakCities VALUES (null, 'Duzab');
INSERT INTO tblPakCities VALUES (null, 'Gajar');
INSERT INTO tblPakCities VALUES (null, 'Gandava');
INSERT INTO tblPakCities VALUES (null, 'Garhi Khairo');
INSERT INTO tblPakCities VALUES (null, 'Garruck');
INSERT INTO tblPakCities VALUES (null, 'Ghazluna');
INSERT INTO tblPakCities VALUES (null, 'Girdan');
INSERT INTO tblPakCities VALUES (null, 'Gulistan');
INSERT INTO tblPakCities VALUES (null, 'Gwadar');
INSERT INTO tblPakCities VALUES (null, 'Gwash');
INSERT INTO tblPakCities VALUES (null, 'Hab Chauki');
INSERT INTO tblPakCities VALUES (null, 'Hameedabad');
INSERT INTO tblPakCities VALUES (null, 'Harnai');
INSERT INTO tblPakCities VALUES (null, 'Hinglaj');
INSERT INTO tblPakCities VALUES (null, 'Hoshab');
INSERT INTO tblPakCities VALUES (null, 'Ispikan');
INSERT INTO tblPakCities VALUES (null, 'Jhal');
INSERT INTO tblPakCities VALUES (null, 'Jhal Jhao');
INSERT INTO tblPakCities VALUES (null, 'Jhatpat');
INSERT INTO tblPakCities VALUES (null, 'Jiwani');
INSERT INTO tblPakCities VALUES (null, 'Kalandi');
INSERT INTO tblPakCities VALUES (null, 'Kalat');
INSERT INTO tblPakCities VALUES (null, 'Kamararod');
INSERT INTO tblPakCities VALUES (null, 'Kanak');
INSERT INTO tblPakCities VALUES (null, 'Kandi');
INSERT INTO tblPakCities VALUES (null, 'Kanpur');
INSERT INTO tblPakCities VALUES (null, 'Kapip');
INSERT INTO tblPakCities VALUES (null, 'Kappar');
INSERT INTO tblPakCities VALUES (null, 'Karodi');
INSERT INTO tblPakCities VALUES (null, 'Katuri');
INSERT INTO tblPakCities VALUES (null, 'Kharan');
INSERT INTO tblPakCities VALUES (null, 'Khuzdar');
INSERT INTO tblPakCities VALUES (null, 'Kikki');
INSERT INTO tblPakCities VALUES (null, 'Kohan');
INSERT INTO tblPakCities VALUES (null, 'Kohlu');
INSERT INTO tblPakCities VALUES (null, 'Korak');
INSERT INTO tblPakCities VALUES (null, 'Lahri');
INSERT INTO tblPakCities VALUES (null, 'Lasbela');
INSERT INTO tblPakCities VALUES (null, 'Liari');
INSERT INTO tblPakCities VALUES (null, 'Loralai');
INSERT INTO tblPakCities VALUES (null, 'Mach');
INSERT INTO tblPakCities VALUES (null, 'Mand');
INSERT INTO tblPakCities VALUES (null, 'Manguchar');
INSERT INTO tblPakCities VALUES (null, 'Mashki Chah');
INSERT INTO tblPakCities VALUES (null, 'Maslti');
INSERT INTO tblPakCities VALUES (null, 'Mastung');
INSERT INTO tblPakCities VALUES (null, 'Mekhtar');
INSERT INTO tblPakCities VALUES (null, 'Merui');
INSERT INTO tblPakCities VALUES (null, 'Mianez');
INSERT INTO tblPakCities VALUES (null, 'Murgha Kibzai');
INSERT INTO tblPakCities VALUES (null, 'Musa Khel Bazar');
INSERT INTO tblPakCities VALUES (null, 'Nagha Kalat');
INSERT INTO tblPakCities VALUES (null, 'Nal');
INSERT INTO tblPakCities VALUES (null, 'Nasirabad');
INSERT INTO tblPakCities VALUES (null, 'Nauroz Kalat');
INSERT INTO tblPakCities VALUES (null, 'Nur Gamma');
INSERT INTO tblPakCities VALUES (null, 'Nushki');
INSERT INTO tblPakCities VALUES (null, 'Nuttal');
INSERT INTO tblPakCities VALUES (null, 'Ormara');
INSERT INTO tblPakCities VALUES (null, 'Palantuk');
INSERT INTO tblPakCities VALUES (null, 'Panjgur');
INSERT INTO tblPakCities VALUES (null, 'Pasni');
INSERT INTO tblPakCities VALUES (null, 'Piharak');
INSERT INTO tblPakCities VALUES (null, 'Pishin');
INSERT INTO tblPakCities VALUES (null, 'Qamruddin Karez');
INSERT INTO tblPakCities VALUES (null, 'Qila Abdullah');
INSERT INTO tblPakCities VALUES (null, 'Qila Ladgasht');
INSERT INTO tblPakCities VALUES (null, 'Qila Safed');
INSERT INTO tblPakCities VALUES (null, 'Qila Saifullah');
INSERT INTO tblPakCities VALUES (null, 'Quetta');
INSERT INTO tblPakCities VALUES (null, 'Rakhni');
INSERT INTO tblPakCities VALUES (null, 'Robat Thana');
INSERT INTO tblPakCities VALUES (null, 'Rodkhan');
INSERT INTO tblPakCities VALUES (null, 'Saindak');
INSERT INTO tblPakCities VALUES (null, 'Sanjawi');
INSERT INTO tblPakCities VALUES (null, 'Saruna');
INSERT INTO tblPakCities VALUES (null, 'Shabaz Kalat');
INSERT INTO tblPakCities VALUES (null, 'Shahpur');
INSERT INTO tblPakCities VALUES (null, 'Sharam Jogizai');
INSERT INTO tblPakCities VALUES (null, 'Shingar');
INSERT INTO tblPakCities VALUES (null, 'Shorap');
INSERT INTO tblPakCities VALUES (null, 'Sibi');
INSERT INTO tblPakCities VALUES (null, 'Sonmiani');
INSERT INTO tblPakCities VALUES (null, 'Spezand');
INSERT INTO tblPakCities VALUES (null, 'Spintangi');
INSERT INTO tblPakCities VALUES (null, 'Sui');
INSERT INTO tblPakCities VALUES (null, 'Suntsar');
INSERT INTO tblPakCities VALUES (null, 'Surab');
INSERT INTO tblPakCities VALUES (null, 'Thalo');
INSERT INTO tblPakCities VALUES (null, 'Tump');
INSERT INTO tblPakCities VALUES (null, 'Turbat');
INSERT INTO tblPakCities VALUES (null, 'Umarao');
INSERT INTO tblPakCities VALUES (null, 'Uthal');
INSERT INTO tblPakCities VALUES (null, 'Vitakri');
INSERT INTO tblPakCities VALUES (null, 'Wadh');
INSERT INTO tblPakCities VALUES (null, 'Washap');
INSERT INTO tblPakCities VALUES (null, 'Wasjuk');
INSERT INTO tblPakCities VALUES (null, 'Yakmach');
INSERT INTO tblPakCities VALUES (null, 'Zhob');
INSERT INTO tblPakCities VALUES (null, 'Bagh');
INSERT INTO tblPakCities VALUES (null, 'Bhimber');
INSERT INTO tblPakCities VALUES (null, 'Kotli');
INSERT INTO tblPakCities VALUES (null, 'Mirpur');
INSERT INTO tblPakCities VALUES (null, 'Muzaffarabad');
INSERT INTO tblPakCities VALUES (null, 'Plandri');
INSERT INTO tblPakCities VALUES (null, 'Rawalakot');
INSERT INTO tblPakCities VALUES (null, 'Pounch');
MT Shahzad
Web/Software Developer
http://mts.sw3solutions.com
User avatar
MT Shahzad
Site Admin
 
Posts: 300
Joined: February 29th, 2008, 8:11 am
Location: Muridke, Pakistan
Top
Post a reply

Return to PHP / MySQL / XML

Who is online

Users browsing this forum: No registered users and 0 guests

Powered by SW3 Solutions - Copyright 2008 © MT Shahzad