<?php
// Ajax via jQuery - RJM Programming tutorial - 2014
 if (isset($_POST['host'])) {
   $ourhost=$_POST['host'];
 } else {
   $ourhost="localhost:8889";
   $ourhost="localhost";
 }
 if (isset($_POST['user'])) {
   $ouruser=$_POST['user'];
 } else {
   $ouruser="youllneverknowifyounevergo";
 }
 if (isset($_POST['password'])) {
   $ourpassword=$_POST['password'];
 } else {
   $ourpassword="wellinever";
 }


mysql_connect($ourhost, $ouruser, $ourpassword);
mysql_select_db('mydb');

if (!isset($_POST['selname'])) {
$query = "SELECT count(*) as numcount FROM country_data";
$numthere = 0;
$result = mysql_query($query);
if (!$result) {

$query = "create table country_data (";
$query .= "  name varchar(255), ";
$query .= "  city varchar(255), ";
$query .= "  cityid varchar(255), ";
$query .= "  index (name), ";
$query .= "  index (city))";

mysql_query($query);

 $query = "INSERT INTO country_data VALUES ('Afghanistan','Kabul','AFG_KABUL'"; 
 $query .= "),('Albania','Tirana','ALB_TIRANA'"; 
 $query .= "),('Algeria','Algiers','DZA_ALGIERS'"; 
 $query .= "),('Algeria','Oran','DZA_ORAN'"; 
 $query .= "),('Andorra','Andorra la Vella','AND_ANDORRA_LA_VELLA'"; 
 $query .= "),('Angola','Luanda','AGO_LUANDA'"; 
 $query .= "),('Argentina','Buenos Aires','ARG_BUENOS_AIRES'"; 
 $query .= "),('Armenia','Yerevan','ARM_YEREVAN'"; 
 $query .= "),('Aruba','Oranjestad','ABW_ORANJESTAD'"; 
 $query .= "),('Australia','Canberra','AUS_CANBERRA'"; 
 $query .= "),('Austria','Vienna','AUT_VIENNA'"; 
 $query .= "),('Azerbaijan','Baku','AZE_BAKU'"; 
 $query .= "),('Bahrain','Manama','BHR_MANAMA'"; 
 $query .= "),('Bangladesh','Dhaka','BGD_DHAKA'"; 
 $query .= "),('Belarus','Minsk','BLR_MINSK'"; 
 $query .= "),('Belgium','Brussels','BEL_BRUSSELS'"; 
 $query .= "),('Belize','Belmopan','BLZ_BELMOPAN'"; 
 $query .= "),('Benin','Cotonou','BEN_COTONOU'"; 
 $query .= "),('Benin','Porto-Novo','BEN_PORTO_NOVO'"; 
 $query .= "),('Bhutan','Thimphu','BTN_THIMPHU'"; 
 $query .= "),('Bolivia','La Paz','BOL_LA_PAZ'"; 
 $query .= "),('Bolivia','Sucre','BOL_SUCRE'"; 
 $query .= "),('Bosnia and Herzegovina','Sarajevo','BIH_SARAJEVO'"; 
 $query .= "),('Botswana','Gaborone','BWA_GABORONE'"; 
 $query .= "),('Brazil','Belo Horizonte','BRA_BELO_HORIZONTE'"; 
 $query .= "),('Brazil','Brasilia','BRA_BRASILIA'"; 
 $query .= "),('Brazil','Campinas','BRA_CAMPINAS'"; 
 $query .= "),('Brazil','Curitiba','BRA_CURITIBA'"; 
 $query .= "),('Brazil','Fortaleza','BRA_FORTALEZA'"; 
 $query .= "),('Brazil','Porto Alegre','BRA_PORTO_ALEGRE'"; 
 $query .= "),('Brazil','Recife','BRA_RECIFE'"; 
 $query .= "),('Brazil','Rio de Janeiro','BRA_RIO_DE_JANEIRO'"; 
 $query .= "),('Brazil','Salvador','BRA_SALVADOR'"; 
 $query .= "),('Brazil','Sao Paulo','BRA_SAO_PAULO'"; 
 $query .= "),('Brunei','Bandar Seri Begawan','BRN_BANDAR_SERI_BEGAWAN'"; 
 $query .= "),('Bulgaria','Sofia','BGR_SOFIA'"; 
 $query .= "),('Burkina Faso','Ouagadougou','BFA_OUAGADOUGOU'"; 
 $query .= "),('Burundi','Bujumbura','BDI_BUJUMBURA'"; 
 $query .= "),('Cambodia','Phnom Penh','KHM_PHNOM_PENH'"; 
 $query .= "),('Cameroon','Douala','CMR_DOUALA'"; 
 $query .= "),('Cameroon','Yaounde','CMR_YAOUNDE'"; 
 $query .= "),('Canada','Montreal','CAN_MONTREAL'"; 
 $query .= "),('Canada','Ottawa','CAN_OTTAWA'"; 
 $query .= "),('Canada','Toronto','CAN_TORONTO'"; 
 $query .= "),('Central African Republic','Bangui','CAF_BANGUI'"; 
 $query .= "),('Chad','N\"Djamena','TCD_N_DJAMENA'"; 
 $query .= "),('Chile','Santiago','CHL_SANTIAGO'"; 
 $query .= "),('China','Beijing','CHN_BEIJING'"; 
 $query .= "),('China','Chongqing','CHN_CHONGQING'"; 
 $query .= "),('China','Guangzhou','CHN_GUANGZHOU'"; 
 $query .= "),('China','Shanghai','CHN_SHANGHAI'"; 
 $query .= "),('China','Shenyang','CHN_SHENYANG'"; 
 $query .= "),('China','Shenzhen','CHN_SHENZHEN'"; 
 $query .= "),('China','Tianjin','CHN_TIANJIN'"; 
 $query .= "),('China','Wuhan','CHN_WUHAN'"; 
 $query .= "),('Colombia','Bogota','COL_BOGOTA'"; 
 $query .= "),('Colombia','Cali','COL_CALI'"; 
 $query .= "),('Colombia','Medellin','COL_MEDELLIN'"; 
 $query .= "),('Congo','Brazzaville','COG_BRAZZAVILLE'"; 
 $query .= "),('Costa Rica','San Jose','CRI_SAN_JOSE'"; 
 $query .= "),('Cote d\"Ivoire','Yamoussoukro','CIV_YAMOUSSOUKRO'"; 
 $query .= "),('Croatia','Zagreb','HRV_ZAGREB'"; 
 $query .= "),('Cuba','Havana','CUB_HAVANA'"; 
 $query .= "),('Cyprus','Nicosia','CYP_NICOSIA'"; 
 $query .= "),('Czech Republic','Prague','CZE_PRAGUE'"; 
 $query .= "),('Democratic Republic of the Congo','Kinshasa','COD_KINSHASA'"; 
 $query .= "),('Denmark','Copenhagen','DNK_COPENHAGEN'"; 
 $query .= "),('Dominican Republic','Santo Domingo','DOM_SANTO_DOMINGO'"; 
 $query .= "),('East Timor','Dili','TLS_DILI'"; 
 $query .= "),('Ecuador','Guayaquil','ECU_GUAYAQUIL'"; 
 $query .= "),('Ecuador','Quito','ECU_QUITO'"; 
 $query .= "),('Egypt','Alexandria','EGY_ALEXANDRIA'"; 
 $query .= "),('Egypt','Cairo','EGY_CAIRO'"; 
 $query .= "),('El Salvador','San Salvador','SLV_SAN_SALVADOR'"; 
 $query .= "),('Equatorial Guinea','Malabo','GNQ_MALABO'"; 
 $query .= "),('Eritrea','Asmara','ERI_ASMARA'"; 
 $query .= "),('Estonia','Tallinn','EST_TALLINN'"; 
 $query .= "),('Ethiopia','Addis Ababa','ETH_ADDIS_ABABA'"; 
 $query .= "),('Falkland Islands','Stanley','FLK_STANLEY'"; 
 $query .= "),('Fiji','Suva','FJI_SUVA'"; 
 $query .= "),('Finland','Helsinki','FIN_HELSINKI'"; 
 $query .= "),('France','Lyon','FRA_LYON'"; 
 $query .= "),('France','Marseille','FRA_MARSEILLE'"; 
 $query .= "),('France','Paris','FRA_PARIS'"; 
 $query .= "),('French Guiana','Cayenne','GUF_CAYENNE'"; 
 $query .= "),('Gabon','Libreville','GAB_LIBREVILLE'"; 
 $query .= "),('Georgia','Tbilisi','GEO_TBILISI'"; 
 $query .= "),('Germany','Berlin','DEU_BERLIN'"; 
 $query .= "),('Germany','Cologne','DEU_COLOGNE'"; 
 $query .= "),('Germany','Hamburg','DEU_HAMBURG'"; 
 $query .= "),('Germany','Munich','DEU_MUNICH'"; 
 $query .= "),('Ghana','Accra','GHA_ACCRA'"; 
 $query .= "),('Ghana','Kumasi','GHA_KUMASI'"; 
 $query .= "),('Greece','Athens','GRC_ATHENS'"; 
 $query .= "),('Greenland','Nuuk','GRL_NUUK'"; 
 $query .= "),('Guatemala','Guatemala City','GTM_GUATEMALA_CITY'"; 
 $query .= "),('Guernsey','St. Peter Port','GGY_ST__PETER_PORT'"; 
 $query .= "),('Guinea','Conakry','GIN_CONAKRY'"; 
 $query .= "),('Guinea-Bissau','Bissau','GNB_BISSAU'"; 
 $query .= "),('Guyana','Georgetown','GUY_GEORGETOWN'"; 
 $query .= "),('Haiti','Port-au-Prince','HTI_PORT_AU_PRINCE'"; 
 $query .= "),('Honduras','Tegucigalpa','HND_TEGUCIGALPA'"; 
 $query .= "),('Hong Kong','Hong Kong','HKG_HONG_KONG'"; 
 $query .= "),('Hungary','Budapest','HUN_BUDAPEST'"; 
 $query .= "),('Iceland','Reykjavik','ISL_REYKJAVIK'"; 
 $query .= "),('India','Ahmedabad','IND_AHMEDABAD'"; 
 $query .= "),('India','Bangalore','IND_BANGALORE'"; 
 $query .= "),('India','Chennai','IND_CHENNAI'"; 
 $query .= "),('India','Delhi','IND_DELHI'"; 
 $query .= "),('India','Hyderabad','IND_HYDERABAD'"; 
 $query .= "),('India','Kolkata','IND_KOLKATA'"; 
 $query .= "),('India','Mumbai','IND_MUMBAI'"; 
 $query .= "),('India','New Delhi','IND_NEW_DELHI'"; 
 $query .= "),('Indonesia','Jakarta','IDN_JAKARTA'"; 
 $query .= "),('Iran','Tehran','IRN_TEHRAN'"; 
 $query .= "),('Iraq','Baghdad','IRQ_BAGHDAD'"; 
 $query .= "),('Ireland','Dublin','IRL_DUBLIN'"; 
 $query .= "),('Isle of Man','Douglas','IMN_DOUGLAS'"; 
 $query .= "),('Israel','Jerusalem','ISR_JERUSALEM'"; 
 $query .= "),('Italy','Milan','ITA_MILAN'"; 
 $query .= "),('Italy','Naples','ITA_NAPLES'"; 
 $query .= "),('Italy','Rome','ITA_ROME'"; 
 $query .= "),('Italy','Turin','ITA_TURIN'"; 
 $query .= "),('Jamaica','Kingston','JAM_KINGSTON'"; 
 $query .= "),('Japan','Nagoya','JPN_NAGOYA'"; 
 $query .= "),('Japan','Osaka','JPN_OSAKA'"; 
 $query .= "),('Japan','Tokyo','JPN_TOKYO'"; 
 $query .= "),('Jordan','Amman','JOR_AMMAN'"; 
 $query .= "),('Kazakhstan','Astana','KAZ_ASTANA'"; 
 $query .= "),('Kenya','Nairobi','KEN_NAIROBI'"; 
 $query .= "),('Kuwait','Kuwait City','KWT_KUWAIT_CITY'"; 
 $query .= "),('Kyrgyzstan','Bishkek','KGZ_BISHKEK'"; 
 $query .= "),('Laos','Vientiane','LAO_VIENTIANE'"; 
 $query .= "),('Latvia','Riga','LVA_RIGA'"; 
 $query .= "),('Lebanon','Beirut','LBN_BEIRUT'"; 
 $query .= "),('Lesotho','Maseru','LSO_MASERU'"; 
 $query .= "),('Liberia','Monrovia','LBR_MONROVIA'"; 
 $query .= "),('Libya','Banghazi','LBY_BANGHAZI'"; 
 $query .= "),('Libya','Tripoli','LBY_TRIPOLI'"; 
 $query .= "),('Liechtenstein','Vaduz','LIE_VADUZ'"; 
 $query .= "),('Lithuania','Vilnius','LTU_VILNIUS'"; 
 $query .= "),('Luxembourg','Luxembourg','LUX_LUXEMBOURG'"; 
 $query .= "),('Macau','Macau','MAC_MACAU'"; 
 $query .= "),('Macedonia','Skopje','MKD_SKOPJE'"; 
 $query .= "),('Madagascar','Antananarivo','MDG_ANTANANARIVO'"; 
 $query .= "),('Malaysia','Kuala Lumpur','MYS_KUALA_LUMPUR'"; 
 $query .= "),('Mali','Bamako','MLI_BAMAKO'"; 
 $query .= "),('Malta','Valletta','MLT_VALLETTA'"; 
 $query .= "),('Mauritania','Nouakchott','MRT_NOUAKCHOTT'"; 
 $query .= "),('Mexico','Guadalajara','MEX_GUADALAJARA'"; 
 $query .= "),('Mexico','Mexico City','MEX_MEXICO_CITY'"; 
 $query .= "),('Mexico','Monterrey','MEX_MONTERREY'"; 
 $query .= "),('Mexico','Puebla','MEX_PUEBLA'"; 
 $query .= "),('Moldova','Chisinau','MDA_CHISINAU'"; 
 $query .= "),('Monaco','Monaco','MCO_MONACO'"; 
 $query .= "),('Mongolia','Ulan Bator','MNG_ULAN_BATOR'"; 
 $query .= "),('Montenegro','Podgorica','MNE_PODGORICA'"; 
 $query .= "),('Morocco','Casablanca','MAR_CASABLANCA'"; 
 $query .= "),('Morocco','Rabat','MAR_RABAT'"; 
 $query .= "),('Mozambique','Maputo','MOZ_MAPUTO'"; 
 $query .= "),('Myanmar','Naypyidaw','MMR_NAYPYIDAW'"; 
 $query .= "),('Namibia','Windhoek','NAM_WINDHOEK'"; 
 $query .= "),('Nepal','Kathmandu','NPL_KATHMANDU'"; 
 $query .= "),('Netherlands','Amsterdam','NLD_AMSTERDAM'"; 
 $query .= "),('Netherlands','Rotterdam','NLD_ROTTERDAM'"; 
 $query .= "),('Netherlands Antilles','Willemstad','ANT_WILLEMSTAD'"; 
 $query .= "),('New Caledonia','Noumea','NCL_NOUMEA'"; 
 $query .= "),('New Zealand','Wellington','NZL_WELLINGTON'"; 
 $query .= "),('Nicaragua','Managua','NIC_MANAGUA'"; 
 $query .= "),('Niger','Niamey','NER_NIAMEY'"; 
 $query .= "),('Nigeria','Abuja','NGA_ABUJA'"; 
 $query .= "),('Nigeria','Ibadan','NGA_IBADAN'"; 
 $query .= "),('Nigeria','Kaduna','NGA_KADUNA'"; 
 $query .= "),('Nigeria','Kano','NGA_KANO'"; 
 $query .= "),('Nigeria','Lagos','NGA_LAGOS'"; 
 $query .= "),('Nigeria','Maiduguri','NGA_MAIDUGURI'"; 
 $query .= "),('Nigeria','Port Harcourt','NGA_PORT_HARCOURT'"; 
 $query .= "),('Nigeria','Zaria','NGA_ZARIA'"; 
 $query .= "),('North Korea','Pyongyang','PRK_PYONGYANG'"; 
 $query .= "),('Norway','Oslo','NOR_OSLO'"; 
 $query .= "),('Oman','Muscat','OMN_MUSCAT'"; 
 $query .= "),('Pakistan','Islamabad','PAK_ISLAMABAD'"; 
 $query .= "),('Pakistan','Karachi','PAK_KARACHI'"; 
 $query .= "),('Pakistan','Lahore','PAK_LAHORE'"; 
 $query .= "),('Panama','Panama City','PAN_PANAMA_CITY'"; 
 $query .= "),('Papua New Guinea','Port Moresby','PNG_PORT_MORESBY'"; 
 $query .= "),('Paraguay','Asuncion','PRY_ASUNCION'"; 
 $query .= "),('Peru','Lima','PER_LIMA'"; 
 $query .= "),('Philippines','Manila','PHL_MANILA'"; 
 $query .= "),('Poland','Warsaw','POL_WARSAW'"; 
 $query .= "),('Portugal','Lisbon','PRT_LISBON'"; 
 $query .= "),('Portugal','Porto','PRT_PORTO'"; 
 $query .= "),('Puerto Rico','San Juan','PRI_SAN_JUAN'"; 
 $query .= "),('Qatar','Al-Doha','QAT_AL_DOHA'"; 
 $query .= "),('Republic of China','Taipei','ROC_TAIPEI'"; 
 $query .= "),('Romania','Bucharest','ROU_BUCHAREST'"; 
 $query .= "),('Russia','Kazan','RUS_KAZAN'"; 
 $query .= "),('Russia','Moscow','RUS_MOSCOW'"; 
 $query .= "),('Russia','Nizhniy Novgorod','RUS_NIZHNIY_NOVGOROD'"; 
 $query .= "),('Russia','Rostov-on-Don','RUS_ROSTOV_ON_DON'"; 
 $query .= "),('Russia','Saint Petersburg','RUS_SAINT_PETERSBURG'"; 
 $query .= "),('Russia','Samara','RUS_SAMARA'"; 
 $query .= "),('Russia','Ufa','RUS_UFA'"; 
 $query .= "),('Rwanda','Kigali','RWA_KIGALI'"; 
 $query .= "),('San Marino','San Marino','SMR_SAN_MARINO'"; 
 $query .= "),('Saudi Arabia','Riyadh','SAU_RIYADH'"; 
 $query .= "),('Senegal','Dakar','SEN_DAKAR'"; 
 $query .= "),('Serbia','Belgrade','SRB_BELGRADE'"; 
 $query .= "),('Sierra Leone','Freetown','SLE_FREETOWN'"; 
 $query .= "),('Singapore','Singapore','SGP_SINGAPORE'"; 
 $query .= "),('Slovakia','Bratislava','SVK_BRATISLAVA'"; 
 $query .= "),('Slovenia','Ljubljana','SVN_LJUBLJANA'"; 
 $query .= "),('Solomon Islands','Honiara','SLB_HONIARA'"; 
 $query .= "),('Somalia','Mogadishu','SOM_MOGADISHU'"; 
 $query .= "),('South Africa','Cape Town','ZAF_CAPE_TOWN'"; 
 $query .= "),('South Africa','Durban','ZAF_DURBAN'"; 
 $query .= "),('South Africa','Johannesburg-Ekurhuleni','ZAF_JOHANNESBURG_EKURHULENI'"; 
 $query .= "),('South Africa','Port Elizabeth','ZAF_PORT_ELIZABETH'"; 
 $query .= "),('South Africa','Pretoria','ZAF_PRETORIA'"; 
 $query .= "),('South Africa','Vereeniging','ZAF_VEREENIGING'"; 
 $query .= "),('South Korea','Seoul','KOR_SEOUL'"; 
 $query .= "),('Spain','Barcelona','ESP_BARCELONA'"; 
 $query .= "),('Spain','Madrid','ESP_MADRID'"; 
 $query .= "),('Sri Lanka','Sri Jayawardenapura Kotte','LKA_SRI_JAYAWARDENAPURA_KOTTE'"; 
 $query .= "),('Sudan','Khartoum','SDN_KHARTOUM'"; 
 $query .= "),('Sudan','Khartoum-Umm Durman','SDN_KHARTOUM_UMM_DURMAN'"; 
 $query .= "),('Suriname','Paramaribo','SUR_PARAMARIBO'"; 
 $query .= "),('Swaziland','Mbabane','SWZ_MBABANE'"; 
 $query .= "),('Sweden','Stockholm','SWE_STOCKHOLM'"; 
 $query .= "),('Switzerland','Berne','CHE_BERNE'"; 
 $query .= "),('Switzerland','Zurich','CHE_ZURICH'"; 
 $query .= "),('Syria','Damascus','SYR_DAMASCUS'"; 
 $query .= "),('Tajikistan','Dushanbe','TJK_DUSHANBE'"; 
 $query .= "),('Tanzania','Dar es Salaam','TZA_DAR_ES_SALAAM'"; 
 $query .= "),('Tanzania','Dodoma','TZA_DODOMA'"; 
 $query .= "),('Thailand','Bangkok','THA_BANGKOK'"; 
 $query .= "),('Togo','Lome','TGO_LOME'"; 
 $query .= "),('Trinidad and Tobago','Port of Spain','TTO_PORT_OF_SPAIN'"; 
 $query .= "),('Tunisia','Tunis','TUN_TUNIS'"; 
 $query .= "),('Turkey','Ankara','TUR_ANKARA'"; 
 $query .= "),('Turkey','Istanbul','TUR_ISTANBUL'"; 
 $query .= "),('Turkmenistan','Ashgabat','TKM_ASHGABAT'"; 
 $query .= "),('Uganda','Kampala','UGA_KAMPALA'"; 
 $query .= "),('Ukraine','Dnipropetrovsk','UKR_DNIPROPETROVSK'"; 
 $query .= "),('Ukraine','Kharkiv','UKR_KHARKIV'"; 
 $query .= "),('Ukraine','Kiev','UKR_KIEV'"; 
 $query .= "),('United Arab Emirates','Abu Dhabi','ARE_ABU_DHABI'"; 
 $query .= "),('United Kingdom','Birmingham','GBR_BIRMINGHAM'"; 
 $query .= "),('United Kingdom','Glasgow','GBR_GLASGOW'"; 
 $query .= "),('United Kingdom','London','GBR_LONDON'"; 
 $query .= "),('United Kingdom','Manchester','GBR_MANCHESTER'"; 
 $query .= "),('United Kingdom','Saint Helier','GBR_SAINT_HELIER'"; 
 $query .= "),('United Kingdom','West Yorkshire','GBR_WEST_YORKSHIRE'"; 
 $query .= "),('United States','Atlanta','USA_ATLANTA'"; 
 $query .= "),('United States','Baltimore','USA_BALTIMORE'"; 
 $query .= "),('United States','Boston','USA_BOSTON'"; 
 $query .= "),('United States','Chicago','USA_CHICAGO'"; 
 $query .= "),('United States','Dallas','USA_DALLAS'"; 
 $query .= "),('United States','Denver','USA_DENVER'"; 
 $query .= "),('United States','Detroit','USA_DETROIT'"; 
 $query .= "),('United States','Houston','USA_HOUSTON'"; 
 $query .= "),('United States','Los Angeles','USA_LOS_ANGELES'"; 
 $query .= "),('United States','Miami','USA_MIAMI'"; 
 $query .= "),('United States','Minneapolis','USA_MINNEAPOLIS'"; 
 $query .= "),('United States','New York','USA_NEW_YORK'"; 
 $query .= "),('United States','Philadelphia','USA_PHILADELPHIA'"; 
 $query .= "),('United States','Phoenix','USA_PHOENIX'"; 
 $query .= "),('United States','Pittsburgh','USA_PITTSBURGH'"; 
 $query .= "),('United States','Riverside-San Bernardino','USA_RIVERSIDE_SAN_BERNARDINO'"; 
 $query .= "),('United States','San Diego','USA_SAN_DIEGO'"; 
 $query .= "),('United States','San Francisco','USA_SAN_FRANCISCO'"; 
 $query .= "),('United States','Seattle','USA_SEATTLE'"; 
 $query .= "),('United States','St. Louis','USA_ST__LOUIS'"; 
 $query .= "),('United States','Tampa','USA_TAMPA'"; 
 $query .= "),('United States','Washington','USA_WASHINGTON'"; 
 $query .= "),('Uruguay','Montevideo','URY_MONTEVIDEO'"; 
 $query .= "),('Uzbekistan','Tashkent','UZB_TASHKENT'"; 
 $query .= "),('Vatican City','Vatican City','VAT_VATICAN_CITY'"; 
 $query .= "),('Venezuela','Caracas','VEN_CARACAS'"; 
 $query .= "),('Venezuela','Maracaibo','VEN_MARACAIBO'"; 
 $query .= "),('Vietnam','Hanoi','VNM_HANOI'"; 
 $query .= "),('Vietnam','Ho Chi Minh City','VNM_HO_CHI_MINH_CITY'"; 
 $query .= "),('Yemen','Aden','YEM_ADEN'"; 
 $query .= "),('Yemen','Sana\"a','YEM_SANA_A'"; 
 $query .= "),('Zambia','Lusaka','ZMB_LUSAKA'"; 
 $query .= "),('Zimbabwe','Harare','ZWE_HARARE'"; 
 $query .= ")"; 

 mysql_query($query);

 } else {
  while($rows = mysql_fetch_array($result)){
   $numthere = $rows['numcount'];
  }
 }
 header("Location: ./getcountrydata.html?insert=done");
} else {
 $modec = "city";

 $selname = $_POST['selname'];
 if (strpos($selname, ",City") !== false) {
  $modec = "name";
  $query = "SELECT name, cityid FROM country_data WHERE upper(country_data.city) RLIKE upper('" . str_replace(",City", "", $selname) . "')";
 } else if (strpos($selname, ",Country") !== false) {
  $query = "SELECT city, cityid FROM country_data WHERE upper(country_data.name) RLIKE upper('" . str_replace(",Country", "", $selname) . "')";
 } else if (!isset($_GET['mode'])) { 
  $query = "SELECT city, cityid FROM country_data WHERE upper(country_data.name) RLIKE upper('$selname')";
 } else if ($_GET['mode'] == "country") {
  $query = "SELECT city, cityid FROM country_data WHERE upper(country_data.name) RLIKE upper('$selname')";
 } else if ($_GET['mode'] == "capital") {
  $modec = "name";
  $query = "SELECT name, cityid FROM country_data WHERE upper(country_data.city) RLIKE upper('$selname')";
 } else {
  $query = "SELECT city, cityid FROM country_data WHERE upper(country_data.name) RLIKE upper('$selname')";
 }
 //file_put_contents("xxx.xxx", $query);
 $result = mysql_query($query) or die(mysql_error());
 $comma = "";
 while($rows = mysql_fetch_array($result)){
  echo $comma;
  echo $rows[$modec];
  echo ',';
  echo $rows['cityid'];
  $comma = ",";
 }
}
?>