homepage Welcome to WebmasterWorld Guest from 54.161.155.142
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
MySQL needed help plz urgently
MySQL needed
hassanzobeen




msg:4353349
 3:11 am on Aug 19, 2011 (gmt 0)

Hello every one
Hope you all will be fine today i need a sql database pre populated with all countries, their states and their cities.
I added a pattern of sql database in codes.
Please provide me as soon as possible or tell me the easiest way to populate the database on this same pattern thanks
waiting for your reply

Database Pattern
-- phpMyAdmin SQL Dump
-- version 3.3.8.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 17, 2011 at 07:22 PM
-- Server version: 5.0.91
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `tubeemne_tubserv`
--

-- --------------------------------------------------------

--
-- Table structure for table `Location_Area`
--

CREATE TABLE IF NOT EXISTS `Location_Area` (
`id` int(11) NOT NULL auto_increment,
`city_id` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`abbreviation` varchar(100) NOT NULL,
`friendly_url` varchar(255) NOT NULL default '',
`seo_description` varchar(255) NOT NULL,
`seo_keywords` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `city_id` (`city_id`),
KEY `friendly_url` (`friendly_url`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `Location_Area`
--


-- --------------------------------------------------------

--
-- Table structure for table `Location_City`
--

CREATE TABLE IF NOT EXISTS `Location_City` (
`id` int(11) NOT NULL auto_increment,
`region_id` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`abbreviation` varchar(100) NOT NULL,
`friendly_url` varchar(255) NOT NULL default '',
`seo_description` varchar(255) NOT NULL,
`seo_keywords` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `region_id` (`region_id`),
KEY `friendly_url` (`friendly_url`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `Location_City`
--


-- --------------------------------------------------------

--
-- Table structure for table `Location_Country`
--

CREATE TABLE IF NOT EXISTS `Location_Country` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`abbreviation` varchar(100) NOT NULL,
`friendly_url` varchar(255) NOT NULL default '',
`seo_description` varchar(255) NOT NULL,
`seo_keywords` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `friendly_url` (`friendly_url`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=236 ;

--
-- Dumping data for table `Location_Country`
--

INSERT INTO `Location_Country` (`id`, `name`, `abbreviation`, `friendly_url`, `seo_description`, `seo_keywords`) VALUES
(235, 'Pakistan', 'PK', 'pakistan', 'Pakistan', 'Pakistan');

-- --------------------------------------------------------

--
-- Table structure for table `Location_Region`
--

CREATE TABLE IF NOT EXISTS `Location_Region` (
`id` int(11) NOT NULL auto_increment,
`state_id` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`abbreviation` varchar(100) NOT NULL,
`friendly_url` varchar(255) NOT NULL default '',
`seo_description` varchar(255) NOT NULL,
`seo_keywords` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `friendly_url` (`friendly_url`),
KEY `state_id` (`state_id`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=780 ;

--
-- Dumping data for table `Location_Region`
--

INSERT INTO `Location_Region` (`id`, `state_id`, `name`, `abbreviation`, `friendly_url`, `seo_description`, `seo_keywords`) VALUES
(771, 3426, 'Peshawar', 'Peshawar', 'peshawar', 'Peshawar', 'Peshawar'),
(690, 3419, 'Mianwali', 'Mianwali', 'mianwali', 'Mianwali', 'Mianwali'),
(689, 3419, 'Mian Channu', 'Mian Channu', 'mian-channu', 'Mian Channu', 'Mian Channu'),
(770, 3426, 'Paharpur', 'Paharpur', 'paharpur', 'Paharpur', 'Paharpur'),
(768, 3426, 'Mingora', 'Mingora', 'mingora', 'Mingora', 'Mingora'),
(769, 3426, 'Nowshera', 'Nowshera', 'nowshera', 'Nowshera', 'Nowshera'),
(686, 3419, 'Mandi Bahauddin', 'Mandi Bahauddin', 'mandi-bahauddin', 'Mandi Bahauddin', 'Mandi Bahauddin'),
(685, 3419, 'Mailsi', 'Mailsi', 'mailsi', 'Mailsi', 'Mailsi'),
(767, 3426, 'Mastuj', 'Mastuj', 'mastuj', 'Mastuj', 'Mastuj'),
(766, 3426, 'Mardan', 'Mardan', 'mardan', 'Mardan', 'Mardan'),
(682, 3419, 'Mamoori', 'Mamoori', 'mamoori', 'Mamoori', 'Mamoori'),
(764, 3426, 'Madyan', 'Madyan', 'madyan', 'Madyan', 'Madyan'),
(765, 3426, 'Mansehra', 'Mansehra', 'mansehra', 'Mansehra', 'Mansehra'),
(763, 3426, 'Latamber', 'Latamber', 'latamber', 'Latamber', 'Latamber'),
(677, 3419, 'Lodhran', 'Lodhran', 'lodhran', 'Lodhran', 'Lodhran'),
(676, 3419, 'Liaquat Pur', 'Liaquat Pur', 'liaquat-pur', 'Liaquat Pur', 'Liaquat Pur'),
(761, 3426, 'Kohat', 'Kohat', 'kohat', 'Kohat', 'Kohat'),
(762, 3426, 'Lakki Marwat', 'Lakki Marwat', 'lakki-marwat', 'Lakki Marwat', 'Lakki Marwat'),
(674, 3419, 'Layyah', 'Layyah', 'layyah', 'Layyah', 'Layyah'),
(760, 3426, 'Karak', 'Karak', 'karak', 'Karak', 'Karak'),
(759, 3426, 'Haripur', 'Haripur', 'haripur', 'Haripur', 'Haripur'),
(671, 3419, 'Lalamusa', 'Lalamusa', 'lalamusa', 'Lalamusa', 'Lalamusa'),
(758, 3426, 'Drosh', 'Drosh', 'drosh', 'Drosh', 'Drosh'),
(757, 3426, 'Dir', 'Dir', 'dir', 'Dir', 'Dir'),
(668, 3419, 'Lahore', 'Lahore', 'lahore', 'Lahore', 'Lahore'),
(667, 3419, 'Jauharabad', 'Jauharabad', 'jauharabad', 'Jauharabad', 'Jauharabad'),
(756, 3426, 'Dera Ismail Khan', 'Dera Ismail Khan', 'dera-ismail-khan', 'Dera Ismail Khan', 'Dera Ismail Khan'),
(755, 3426, 'Darya Khan', 'Darya Khan', 'darya-khan', 'Darya Khan', 'Darya Khan'),
(664, 3419, 'Kot Adu', 'Kot Adu', 'kot-adu', 'Kot Adu', 'Kot Adu'),
(663, 3419, 'Khushab', 'Khushab', 'khushab', 'Khushab', 'Khushab'),
(753, 3426, 'Daggar', 'Daggar', 'daggar', 'Daggar', 'Daggar'),
(754, 3426, 'Dargai', 'Dargai', 'dargai', 'Dargai', 'Dargai'),
(661, 3419, 'Kharian', 'Kharian', 'kharian', 'Kharian', 'Kharian'),
(660, 3419, 'Khanpur', 'Khanpur', 'khanpur', 'Khanpur', 'Khanpur'),
(751, 3426, 'Charsadda', 'Charsadda', 'charsadda', 'Charsadda', 'Charsadda'),
(752, 3426, 'Chitral', 'Chitral', 'chitral', 'Chitral', 'Chitral'),
(657, 3419, 'Khanewal', 'Khanewal', 'khanewal', 'Khanewal', 'Khanewal'),
(656, 3419, 'Kāmoke', 'Kāmoke', 'kmoke', 'Kāmoke', 'Kāmoke'),
(655, 3419, 'Kamalia', 'Kamalia', 'kamalia', 'Kamalia', 'Kamalia'),
(750, 3426, 'Chakdara', 'Chakdara', 'chakdara', 'Chakdara', 'Chakdara'),
(653, 3419, 'Kasur', 'Kasur', 'kasur', 'Kasur', 'Kasur'),
(652, 3419, 'Karor Lal Esan', 'Karor Lal Esan', 'karor-lal-esan', 'Karor Lal Esan', 'Karor Lal Esan'),
(749, 3426, 'Birote', 'Birote', 'birote', 'Birote', 'Birote'),
(650, 3419, 'Kalabagh', 'Kalabagh', 'kalabagh', 'Kalabagh', 'Kalabagh'),
(776, 3426, 'Tank', 'Tank', 'tank', 'Tank', 'Tank'),
(648, 3419, 'Jhelum', 'Jhelum', 'jhelum', 'Jhelum', 'Jhelum'),
(647, 3419, 'Jhang', 'Jhang', 'jhang', 'Jhang', 'Jhang'),
(777, 3426, 'Thall', 'Thall', 'thall', 'Thall', 'Thall'),
(778, 3426, 'Timergara', 'Timergara', 'timergara', 'Timergara', 'Timergara'),
(645, 3419, 'Jaranwala ', 'Jaranwala ', 'jaranwala', 'Jaranwala\r\n', 'Jaranwala\r\n'),
(644, 3419, 'Jampur', 'Jampur', 'jampur', 'Jampur', 'Jampur'),
(643, 3419, 'Jalalpur Jattan', 'Jalalpur Jattan', 'jalalpur-jattan', 'Jalalpur Jattan', 'Jalalpur Jattan'),
(642, 3419, 'Haveli Lakha', 'Haveli Lakha', 'haveli-lakha', 'Haveli Lakha', 'Haveli Lakha'),
(641, 3419, 'Hafizabad', 'Hafizabad', 'hafizabad', 'Hafizabad', 'Hafizabad'),
(640, 3419, 'Haroonabad', 'Haroonabad', 'haroonabad', 'Haroonabad', 'Haroonabad'),
(639, 3420, 'Warah', 'Warah', 'warah', 'Warah', 'Warah'),
(638, 3420, 'Umerkot', 'Umerkot', 'umerkot', 'Umerkot', 'Umerkot'),
(637, 3419, 'Gujar Khan', 'Gujar Khan', 'gujar-khan', 'Gujar Khan', 'Gujar Khan'),
(636, 3420, 'Qasimabad', 'Qasimabad', 'qasimabad', 'Qasimabad', 'Qasimabad'),
(635, 3419, 'Gujrat', 'Gujrat', 'gujrat', 'Gujrat', 'Gujrat'),
(634, 3420, 'Thatta', 'Thatta', 'thatta', 'Thatta', 'Thatta'),
(633, 3419, 'Gujranwala', 'Gujranwala', 'gujranwala', 'Gujranwala', 'Gujranwala'),
(632, 3420, 'Tando Muhammad Khan', 'Tando Muhammad Khan', 'tando-muhammad-khan', 'Tando Muhammad Khan', 'Tando Muhammad Khan'),
(631, 3419, 'Gojra', 'Gojra', 'gojra', 'Gojra', 'Gojra'),
(630, 3420, 'Tando Allahyar', 'Tando Allahyar', 'tando-allahyar', 'Tando Allahyar', 'Tando Allahyar'),
(629, 3419, 'Ghakhar Mandi', 'Ghakhar Mandi', 'ghakhar-mandi', 'Ghakhar Mandi', 'Ghakhar Mandi'),
(628, 3420, 'Tando Adam Khan', 'Tando Adam Khan', 'tando-adam-khan', 'Tando Adam Khan', 'Tando Adam Khan'),
(627, 3420, 'Sukkur', 'Sukkur', 'sukkur', 'Sukkur', 'Sukkur'),
(626, 3419, 'Fateh Jang', 'Fateh Jang', 'fateh-jang', 'Fateh Jang', 'Fateh Jang'),
(625, 3420, 'Shikarpaur', 'Shikarpaur', 'shikarpaur', 'Shikarpaur', 'Shikarpaur'),
(624, 3419, 'Dibalpur', 'Dibalpur', 'dibalpur', 'Dibalpur', 'Dibalpur'),
(623, 3420, 'Shahpur Chakar', 'Shahpur Chakar', 'shahpur-chakar', 'Shahpur Chakar', 'Shahpur Chakar'),
(622, 3420, 'Shahdadpur', 'Shahdadpur', 'shahdadpur', 'Shahdadpur', 'Shahdadpur'),
(621, 3420, 'Shahdadkot', 'Shahdadkot', 'shahdadkot', 'Shahdadkot', 'Shahdadkot'),
(620, 3419, 'Faisalabad', 'Faisalabad', 'faisalabad', 'Faisalabad', 'Faisalabad'),
(619, 3420, 'Shahbandar', 'Shahbandar', 'shahbandar', 'Shahbandar', 'Shahbandar'),
(618, 3420, 'Sanghar', 'Sanghar', 'sanghar', 'Sanghar', 'Sanghar'),
(617, 3420, 'Sakrand', 'Sakrand', 'sakrand', 'Sakrand', 'Sakrand'),
(616, 3420, 'Rohri', 'Rohri', 'rohri', 'Rohri', 'Rohri'),
(615, 3420, 'Ratodero', 'Ratodero', 'ratodero', 'Ratodero', 'Ratodero'),
(614, 3419, 'Dinga', 'Dinga', 'dinga', 'Dinga', 'Dinga'),
(613, 3420, 'Ranipur', 'Ranipur', 'ranipur', 'Ranipur', 'Ranipur'),
(612, 3419, 'Dina', 'Dina', 'dina', 'Dina', 'Dina'),
(611, 3420, 'Nazimabad', 'Nazimabad', 'nazimabad', 'Nazimabad', 'Nazimabad'),
(610, 3420, 'Nawabshah', 'Nawabshah', 'nawabshah', 'Nawabshah', 'Nawabshah\r\n'),
(609, 3419, 'Dhaular', 'Dhaular', 'dhaular', 'Dhaular', 'Dhaular'),
(608, 3419, 'Dera Ghazi Khan', 'Dera Ghazi Khan', 'dera-ghazi-khan', 'Dera Ghazi Khan', 'Dera Ghazi Khan'),
(607, 3420, 'Naushara', 'Naushara', 'naushara', 'Naushara', 'Naushara'),
(606, 3420, 'Naushahro Feroze', 'Naushahro Feroze', 'naushahro-feroze', 'Naushahro Feroze', 'Naushahro Feroze'),
(605, 3420, 'Naudero', 'Naudero', 'naudero', 'Naudero', 'Naudero'),
(604, 3420, 'Nagarparkar', 'Nagarparkar', 'nagarparkar', 'Nagarparkar', 'Nagarparkar'),
(603, 3419, 'Darya Khan', 'Darya Khan', 'darya-khan', 'Darya Khan', 'Darya Khan'),
(602, 3419, 'Daska', 'Daska', 'daska', 'Daska', 'Daska'),
(601, 3419, 'Chishtian', 'Chishtian', 'chishtian', 'Chishtian', 'Chishtian'),
(600, 3419, 'Chiniot', 'Chiniot', 'chiniot', 'Chiniot', 'Chiniot'),
(599, 3419, 'Chichawatni', 'Chichawatni', 'chichawatni', 'Chichawatni', 'Chichawatni'),
(598, 3419, 'Chakwal', 'Chakwal', 'chakwal', 'Chakwal', 'Chakwal'),
(597, 3419, 'Chillianwala', 'Chillianwala', 'chillianwala', 'Chillianwala', 'Chillianwala'),
(596, 3419, 'Burewala', 'Burewala', 'burewala', 'Burewala', 'Burewala'),
(595, 3419, 'Bhakkar', 'Bhakkar', 'bhakkar', 'Bhakkar', 'Bhakkar'),
(594, 3420, 'Moro', 'Moro', 'moro', 'Moro', 'Moro'),
(593, 3420, 'Mehrabpur', 'Mehrabpur', 'mehrabpur', 'Mehrabpur', 'Mehrabpur'),
(592, 3420, 'Mithi', 'Mithi', 'mithi', 'Mithi', 'Mithi'),
(591, 3420, 'Mithani', 'Mithani', 'mithani', 'Mithani', 'Mithani'),
(590, 3420, 'Mirpur Khas', 'Mirpur Khas', 'mirpur-khas', 'Mirpur Khas', 'Mirpur Khas'),
(589, 3420, 'Mehar', 'Mehar', 'mehar', 'Mehar', 'Mehar'),
(588, 3420, 'Matiari', 'Matiari', 'matiari', 'Matiari', 'Matiari'),
(587, 3420, 'Larkana', 'Larkana', 'larkana', 'Larkana', 'Larkana'),
(586, 3420, 'Kotri', 'Kotri', 'kotri', 'Kotri', 'Kotri'),
(585, 3420, 'Khairpur', 'Khairpur', 'khairpur', 'Khairpur', 'Khairpur'),
(584, 3419, 'Bahawalpur', 'Bahawalpur', 'bahawalpur', 'Bahawalpur', 'Bahawalpur'),
(583, 3420, 'Keti Bandar', 'Keti Bandar', 'keti-bandar', 'Keti Bandar', 'Keti Bandar'),
(582, 3419, 'Bahawalnagar', 'Bahawalnagar', 'bahawalnagar', 'Bahawalnagar', 'Bahawalnagar'),
(581, 3420, 'Kashmore', 'Kashmore', 'kashmore', 'Kashmore', 'Kashmore'),
(580, 3420, 'Karachi', 'Karachi', 'karachi', 'Karachi', 'Karachi'),
(579, 3419, 'Bhalwal', 'Bhalwal', 'bhalwal', 'Bhalwal', 'Bhalwal'),
(578, 3419, 'Attock', 'Attock', 'attock', 'Attock', 'Attock'),
(577, 3420, 'Kandiaro', 'Kandiaro', 'kandiaro', 'Kandiaro', 'Kandiaro'),
(576, 3420, 'Kandhkot', 'Kandhkot', 'kandhkot', 'Kandhkot', 'Kandhkot'),
(575, 3420, 'Jungshahi', 'Jungshahi', 'jungshahi', 'Jungshahi', 'Jungshahi'),
(574, 3419, 'Arifwala', 'Arifwala', 'arifwala', 'Arifwala', 'Arifwala'),
(573, 3420, 'Jamshoro', 'Jamshoro', 'jamshoro', 'Jamshoro', 'Jamshoro'),
(572, 3420, 'Jacobabad', 'Jacobabad', 'jacobabad', 'Jacobabad', 'Jacobabad'),
(571, 3420, 'Islamkot', 'Islamkot', 'islamkot', 'Islamkot', 'Islamkot'),
(570, 3419, 'Alipur', 'Alipur', 'alipur', 'Alipur', 'Alipur'),
(569, 3420, 'Hyderabad', 'Hyderabad', 'hyderabad', 'Hyderabad', 'Hyderabad'),
(568, 3420, 'Haala', 'Haala', 'haala', 'Haala', 'Haala'),
(567, 3420, 'Ghotki', 'Ghotki', 'ghotki', 'Ghotki', 'Ghotki'),
(566, 3420, 'Dokri', 'Dokri', 'dokri', 'Dokri', 'Dokri'),
(565, 3420, 'Diplo', 'Diplo', 'diplo', 'Diplo', 'Diplo'),
(564, 3420, 'Digri', 'Digri', 'digri', 'Digri', 'Digri'),
(563, 3419, 'Ahmed Nager Chatha', 'Ahmed Nager Chatha', 'ahmed-nager-chatha', 'Ahmed Nager Chatha', 'Ahmed Nager Chatha'),
(562, 3419, 'Ahmadpur East', 'Ahmadpur East', 'ahmadpur-east', 'Ahmadpur East', 'Ahmadpur East'),
(561, 3420, 'Dadu', 'Dadu', 'dadu', 'Dadu', 'Dadu'),
(560, 3420, 'Chak', 'Chak', 'chak', 'Chak', 'Chak'),
(559, 3420, 'Rajo Khanani', 'Rajo Khanani', 'rajo-khanani', 'Rajo Khanani', 'Rajo Khanani'),
(558, 3420, 'Bhirkan', 'Bhirkan', 'bhirkan', 'Bhirkan', 'Bhirkan'),
(557, 3420, 'Badin', 'Badin', 'badin', 'Badin', 'Badin'),
(556, 3421, 'Islamabad', 'Islamabad', 'islamabad', 'Islamabad', 'Islamabad'),
(772, 3426, 'Saidu Sharif', 'Saidu Sharif', 'saidu-sharif', 'Saidu Sharif', 'Saidu Sharif'),
(773, 3426, 'Swabi', 'Swabi', 'swabi', 'Swabi', 'Swabi'),
(774, 3426, 'Swat', 'Swat', 'swat', 'Swat', 'Swat'),
(775, 3426, 'Tangi', 'Tangi', 'tangi', 'Tangi', 'Tangi'),
(552, 3417, 'Kalat', 'Kalat', 'kalat', 'Kalat', 'Kalat'),
(551, 3417, 'Nushki', 'Nushki', 'nushki', 'Nushki', 'Nushki'),
(550, 3417, 'Mastung', 'Mastung', 'mastung', 'Mastung', 'Mastung'),
(549, 3417, 'Kharan', 'Kharan', 'kharan', 'Kharan', 'Kharan'),
(548, 3417, 'Pasni', 'Pasni', 'pasni', 'Pasni', 'Pasni'),
(547, 3417, 'Loralai', 'Loralai', 'loralai', 'Loralai', 'Loralai'),
(546, 3417, 'Usta Mohammad', 'Usta Mohammad', 'usta-mohammad', 'Usta Mohammad', 'Usta Mohammad'),
(545, 3417, 'Dera Allah Yar', 'Dera Allah Yar', 'dera-allah-yar', 'Dera Allah Yar', 'Dera Allah Yar'),
(544, 3417, 'Dera Murad Jamali', 'Dera Murad Jamali', 'dera-murad-jamali', 'Dera Murad Jamali', 'Dera Murad Jamali'),
(543, 3417, 'Gwadar', 'Gwadar', 'gwadar', 'Gwadar', 'Gwadar'),
(542, 3417, 'Zhob', 'Zhob', 'zhob', 'Zhob', 'Zhob'),
(541, 3417, 'Sibi', 'Sibi', 'sibi', 'Sibi', 'Sibi'),
(540, 3417, 'Hub', 'Hub', 'hub', 'Hub', 'Hub'),
(539, 3417, 'Chaman', 'Chaman', 'chaman', 'Chaman', 'Chaman'),
(538, 3417, 'Turbat', 'Turbat', 'turbat', 'Turbat', 'Turbat'),
(537, 3417, 'Khuzdar', 'Khuzdar', 'khuzdar', 'Khuzdar', 'Khuzdar'),
(536, 3417, 'Quetta', 'Quetta', 'quetta', 'Quetta', 'Quetta'),
(535, 3424, 'Thorar', 'Thorar', 'thorar', 'Thorar', 'Thorar'),
(534, 3424, 'Taghafari', 'Taghafari', 'taghafari', 'Taghafari', 'Taghafari'),
(533, 3424, 'Sust', 'Sust', 'sust', 'Sust', 'Sust'),
(532, 3424, 'Skardu', 'Skardu', 'skardu', 'Skardu', 'Skardu'),
(531, 3424, 'Shimshal', 'Shimshal', 'shimshal', 'Shimshal', 'Shimshal'),
(530, 3424, 'Passu', 'Passu', 'passu', 'Passu', 'Passu'),
(529, 3424, 'Misgar', 'Misgar', 'misgar', 'Misgar', 'Misgar'),
(528, 3424, 'Minimerg', 'Minimerg', 'minimerg', 'Minimerg', 'Minimerg'),
(527, 3424, 'Khaplu', 'Khaplu', 'khaplu', 'Khaplu', 'Khaplu'),
(526, 3424, 'Ishkoman', 'Ishkoman', 'ishkoman', 'Ishkoman', 'Ishkoman'),
(525, 3424, 'Karimabad (Hunza)', 'Karimabad (Hunza)', 'karimabad-hunza', 'Karimabad (Hunza)', 'Karimabad (Hunza)'),
(524, 3424, 'Ghulmat (Nagar)', 'Ghulmat (Nagar)', 'ghulmat-nagar', 'Ghulmat (Nagar)', 'Ghulmat (Nagar)'),
(523, 3424, 'Nagar Proper', 'Nagar Proper', 'nagar-proper', 'Nagar Proper', 'Nagar Proper'),
(522, 3424, 'Qasimabad Masoot (Nagar)', 'Qasimabad Masoot (Nagar)', 'qasimabad-masoot-nagar', 'Qasimabad Masoot (Nagar)', 'Qasimabad Masoot (Nagar)'),
(521, 3424, 'Thole (Nagar)', 'Thole (Nagar)', 'thole-nagar', 'Thole (Nagar)', 'Thole (Nagar)'),
(520, 3424, 'Chalt (Nagar)', 'Chalt (Nagar)', 'chalt-nagar', 'Chalt (Nagar)', 'Chalt (Nagar)'),
(519, 3424, 'Jaglot', 'Jaglot', 'jaglot', 'Jaglot', 'Jaglot'),
(518, 3424, 'Gulmit', 'Gulmit', 'gulmit', 'Gulmit', 'Gulmit'),
(517, 3424, 'Gorikot', 'Gorikot', 'gorikot', 'Gorikot', 'Gorikot'),
(516, 3424, 'Gilgit', 'Gilgit', 'gilgit', 'Gilgit', 'Gilgit'),
(515, 3424, 'Ghizer', 'Ghizer', 'ghizer', 'Ghizer', 'Ghizer'),
(514, 3424, 'Ghangche', 'Ghangche', 'ghangche', 'Ghangche', 'Ghangche'),
(513, 3424, 'Gakuch', 'Gakuch', 'gakuch', 'Gakuch', 'Gakuch'),
(512, 3424, 'Chiran', 'Chiran', 'chiran', 'Chiran', 'Chiran'),
(511, 3424, 'Chillinji', 'Chillinji', 'chillinji', 'Chillinji', 'Chillinji'),
(510, 3424, 'Chilas', 'Chilas', 'chilas', 'Chilas', 'Chilas'),
(509, 3424, 'Bunji (or Boanzhi)', 'Bunji (or Boanzhi)', 'bunji-or-boanzhi', 'Bunji (or Boanzhi)', 'Bunji (or Boanzhi)'),
(508, 3424, 'Astore', 'Astore', 'astore', 'Astore', 'Astore'),
(507, 3424, 'Askole', 'Askole', 'askole', 'Askole', 'Askole'),
(506, 3422, 'Wana', 'Wana', 'wana', 'Wana', 'Wana'),
(505, 3422, 'Sadda', 'Sadda', 'sadda', 'Sadda', 'Sadda'),
(504, 3422, 'Razmak', 'Razmak', 'razmak', 'Razmak', 'Razmak'),
(503, 3422, 'Parachinar', 'Parachinar', 'parachinar', 'Parachinar', 'Parachinar'),
(502, 3422, 'Miranshah', 'Miranshah', 'miranshah', 'Miranshah', 'Miranshah'),
(501, 3422, 'Mir Ali', 'Mir Ali', 'mir-ali', 'Mir Ali', 'Mir Ali'),
(500, 3422, 'Makeen', 'Makeen', 'makeen', 'Makeen', 'Makeen'),
(499, 3422, 'Landi Kotal', 'Landi Kotal', 'landi-kotal', 'Landi Kotal', 'Landi Kotal'),
(498, 3422, 'Khar', 'Khar', 'khar', 'Khar', 'Khar'),
(497, 3422, 'Jamrud', 'Jamrud', 'jamrud', 'Jamrud', 'Jamrud'),
(496, 3422, 'Ghulam Khana', 'Ghulam Khana', 'ghulam-khana', 'Ghulam Khana', 'Ghulam Khana'),
(495, 3422, 'Darra Adam Khel', 'Darra Adam Khel', 'darra-adam-khel', 'Darra Adam Khel', 'Darra Adam Khel'),
(494, 3422, 'Bara', 'Bara', 'bara', 'Bara', 'Bara'),
(493, 3422, 'Alizai', 'Alizai', 'alizai', 'Alizai', 'Alizai'),
(492, 3423, 'Pindi Bhatian', 'Pindi Bhatian', 'pindi-bhatian', 'Pindi Bhatian', 'Pindi Bhatian'),
(491, 3423, 'Hattian', 'Hattian', 'hattian', 'Hattian', 'Hattian'),
(490, 3423, 'Havelli,Farward Kahutta', 'Havelli,Farward Kahutta', 'havellifarward-kahutta', 'Havelli,Farward Kahutta', 'Havelli,Farward Kahutta'),
(489, 3423, 'Muzaffarabad', 'Muzaffarabad', 'muzaffarabad', 'Muzaffarabad', 'Muzaffarabad'),
(488, 3423, 'Mirpur', 'Mirpur', 'mirpur', 'Mirpur', 'Mirpur'),
(487, 3423, 'Mangla', 'Mangla', 'mangla', 'Mangla', 'Mangla'),
(486, 3423, 'Kotli', 'Kotli', 'kotli', 'Kotli', 'Kotli'),
(485, 3423, 'Khuiratta', 'Khuiratta', 'khuiratta', 'Khuiratta', 'Khuiratta'),
(484, 3423, 'Bhimber', 'Bhimber', 'bhimber', 'Bhimber', 'Bhimber'),
(483, 3423, 'Bagh', 'Bagh', 'bagh', 'Bagh', 'Bagh'),
(482, 3423, 'Rawalakot', 'Rawalakot', 'rawalakot', 'Rawalakot', 'Rawalakot'),
(693, 3419, 'Multan', 'Multan', 'multan', 'Multan', 'Multan'),
(694, 3419, 'Murree', 'Murree', 'murree', 'Murree', 'Murree'),
(696, 3419, 'Muridke', 'Muridke', 'muridke', 'Muridke', 'Muridke'),
(748, 3426, 'Battagram', 'Battagram', 'battagram', 'Battagram', 'Battagram'),
(698, 3419, 'Mianwali Bangla', 'Mianwali Bangla', 'mianwali-bangla', 'Mianwali Bangla', 'Mianwali Bangla'),
(747, 3426, 'Batkhela', 'Batkhela', 'batkhela', 'Batkhela', 'Batkhela'),
(700, 3419, 'Muzaffargarh', 'Muzaffargarh', 'muzaffargarh', 'Muzaffargarh', 'Muzaffargarh'),
(701, 3419, 'Narowal', 'Narowal', 'narowal', 'Narowal', 'Narowal'),
(702, 3419, 'Okara', 'Okara', 'okara', 'Okara', 'Okara'),
(746, 3426, 'Bannu', 'Bannu', 'bannu', 'Bannu', 'Bannu'),
(704, 3419, 'Renala Khurd', 'Renala Khurd', 'renala-khurd', 'Renala Khurd', 'Renala Khurd'),
(706, 3419, 'Pakpattan', 'Pakpattan', 'pakpattan', 'Pakpattan', 'Pakpattan'),
(745, 3426, 'Banda Daud Shah', 'Banda Daud Shah', 'banda-daud-shah', 'Banda Daud Shah', 'Banda Daud Shah'),
(708, 3419, 'Pattoki', 'Pattoki', 'pattoki', 'Pattoki', 'Pattoki'),
(744, 3426, 'Ayubia', 'Ayubia', 'ayubia', 'Ayubia', 'Ayubia'),
(710, 3419, 'Pir Mahal', 'Pir Mahal', 'pir-mahal', 'Pir Mahal', 'Pir Mahal'),
(712, 3419, 'Qila Didar Singh', 'Qila Didar Singh', 'qila-didar-singh', 'Qila Didar Singh', 'Qila Didar Singh'),
(743, 3426, 'Alpuri', 'Alpuri', 'alpuri', 'Alpuri', 'Alpuri'),
(714, 3419, 'Rabwah', 'Rabwah', 'rabwah', 'Rabwah', 'Rabwah'),
(716, 3419, 'Raiwind', 'Raiwind', 'raiwind', 'Raiwind', 'Raiwind'),
(742, 3426, 'Adezai', 'Adezai', 'adezai', 'Adezai', 'Adezai'),
(718, 3419, 'Rajanpur', 'Rajanpur', 'rajanpur', 'Rajanpur', 'Rajanpur'),
(720, 3419, 'Rahim Yar Khan', 'Rahim Yar Khan', 'rahim-yar-khan', 'Rahim Yar Khan', 'Rahim Yar Khan'),
(741, 3426, 'Abbottabad', 'Abbottabad', 'abbottabad', 'Abbottabad', 'Abbottabad'),
(722, 3419, 'Rawalpindi', 'Rawalpindi', 'rawalpindi', 'Rawalpindi', 'Rawalpindi'),
(723, 3419, 'Sadiqabad', 'Sadiqabad', 'sadiqabad', 'Sadiqabad', 'Sadiqabad'),
(724, 3419, 'Safdarabad', 'Safdarabad', 'safdarabad', 'Safdarabad', 'Safdarabad'),
(725, 3419, 'Sahiwal', 'Sahiwal', 'sahiwal', 'Sahiwal', 'Sahiwal'),
(726, 3419, 'Sangla Hill', 'Sangla Hill', 'sangla-hill', 'Sangla Hill', 'Sangla Hill'),
(727, 3419, 'Sarai Alamgir', 'Sarai Alamgir', 'sarai-alamgir', 'Sarai Alamgir', 'Sarai Alamgir'),
(728, 3419, 'Sargodha', 'Sargodha', 'sargodha', 'Sargodha', 'Sargodha'),
(729, 3419, 'Shakargarh', 'Shakargarh', 'shakargarh', 'Shakargarh', 'Shakargarh'),
(730, 3419, 'Sheikhupura', 'Sheikhupura', 'sheikhupura', 'Sheikhupura', 'Sheikhupura'),
(731, 3419, 'Sialkot', 'Sialkot', 'sialkot', 'Sialkot', 'Sialkot'),
(732, 3419, 'Sohawa', 'Sohawa', 'sohawa', 'Sohawa', 'Sohawa'),
(733, 3419, 'Soianwala', 'Soianwala', 'soianwala', 'Soianwala', 'Soianwala'),
(734, 3419, 'Siranwali', 'Siranwali', 'siranwali', 'Siranwali', 'Siranwali'),
(735, 3419, 'Talagang', 'Talagang', 'talagang', 'Talagang', 'Talagang'),
(736, 3419, 'Taxila', 'Taxila', 'taxila', 'Taxila', 'Taxila'),
(737, 3419, 'Toba Tek Singh', 'Toba Tek Singh', 'toba-tek-singh', 'Toba Tek Singh', 'Toba Tek Singh'),
(738, 3419, 'Vehari', 'Vehari', 'vehari', 'Vehari', 'Vehari'),
(739, 3419, 'Wah Cantonment', 'Wah Cantonment', 'wah-cantonment', 'Wah Cantonment', 'Wah Cantonment'),
(740, 3419, 'Wazirabad', 'Wazirabad', 'wazirabad', 'Wazirabad', 'Wazirabad'),
(779, 3426, 'Tordher', 'Tordher', 'tordher', 'Tordher', 'Tordher');

-- --------------------------------------------------------

--
-- Table structure for table `Location_State`
--

CREATE TABLE IF NOT EXISTS `Location_State` (
`id` int(11) NOT NULL auto_increment,
`country_id` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`abbreviation` varchar(100) NOT NULL,
`friendly_url` varchar(255) NOT NULL default '',
`popular` char(1) NOT NULL default 'n',
`seo_description` varchar(255) NOT NULL,
`seo_keywords` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `friendly_url` (`friendly_url`),
KEY `country_id` (`country_id`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3427 ;

--
-- Dumping data for table `Location_State`
--

INSERT INTO `Location_State` (`id`, `country_id`, `name`, `abbreviation`, `friendly_url`, `popular`, `seo_description`, `seo_keywords`) VALUES
(3417, 235, 'Balochistan', 'Balochistan', 'balochistan', 'y', 'Balochistan', 'Balochistan'),
(3419, 235, 'Punjab', 'Punjab', 'punjab', 'y', 'Punjab', 'Punjab'),
(3420, 235, 'Sindh', 'Sindh', 'sindh', 'y', 'Sindh', 'Sindh'),
(3421, 235, 'Islamabad Capital Territory', 'Islamabad Capital Territory', 'islamabad-capital-territory', 'y', 'Islamabad Capital Territory', 'Islamabad Capital Territory'),
(3422, 235, 'Federally Administered Tribal Areas', 'Federally Administered Tribal Areas', 'federally-administered-tribal-areas', 'n', 'Federally Administered Tribal Areas', 'Federally Administered Tribal Areas'),
(3423, 235, 'Azad Jammu Kashmir', 'Azad Jammu Kashmir', 'azad-jammu-kashmir', 'y', 'Azad Jammu Kashmir', 'Azad Jammu Kashmir'),
(3424, 235, 'Gilgit-Baltistan', 'Gilgit-Baltistan', 'gilgit-baltistan', 'y', 'Gilgit-Baltistan', 'Gilgit-Baltistan'),
(3426, 235, 'Khyber Pakhtunkhwa', 'Khyber Pakhtunkhwa', 'khyber-pakhtunkhwa', 'n', 'Khyber Pakhtunkhwa', 'Khyber Pakhtunkhwa');

 

hassanzobeen




msg:4353769
 2:21 pm on Aug 20, 2011 (gmt 0)

Plz helppppppppppppppppppppppp

rocknbil




msg:4354235
 3:51 pm on Aug 22, 2011 (gmt 0)

I don't think anyone understands the question, including myself. If that's the data you need, all you have to do is import it into the database, via command line or phpMyAdmin.

topr8




msg:4354240
 4:19 pm on Aug 22, 2011 (gmt 0)

the example shows Pakistan.

i think the OP is asking where he can get similar data (free i assume) for all the other countries in the world.

i can guess what for ...

as a starting point it is possible to develop a list of all the countries for the countries table from the data here:
[iso.org...]

i've no idea where to get region, state and city lists, however probably not all countries in the world would follow that format anyway, for instance the UK doesn't really have 'location areas' or 'regions' in the same way.

hassanzobeen




msg:4355421
 4:05 am on Aug 26, 2011 (gmt 0)

Yes you are right topr8
I need the same sql full for all countries, states and cities

can you please help

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved