";
}
?>
isMobile()) {
print"
";
}
else
{
print"
";
}
?>
isMobile()) {
}
else{
print"
";
include("templates/template_left.html");
print"
";
}
if ($detect->isMobile()) {
print"";
}
else
{
print"
";
}
?>
";
$sql_table_check = "SHOW TABLES LIKE '".$table."'";
$table_check_result = mysql_query($sql_table_check);
if($table_check_result)
{
if( mysql_num_rows($table_check_result))
{
//if($table!="")
//{
//$indexArray = split("-",$r);
//$theCondition="theIndex = 1000000";
//for($a=1;$a$line[1]";
//$relatedLink=str_replace('^^','',$relatedLink);
//echo "$relatedLink ";
//}
//}
//}
//}
$querydb="select tblDatabaseDriven.fileName, tblDatabaseDriven.condition, tblDatabaseDriven.related, tblDatabaseDriven.dataTable, tblDatabaseDriven.measure2, tblDatabaseDriven.columns, tblDatabaseDriven.display,tblDatabaseDriven.location FROM tblDatabaseDriven where tblDatabaseDriven.fileName=\"$file\"";
$resultdb=mysql_query($querydb);
$relatedKey=-1;
if($resultdb)
{
$linedb=mysql_fetch_array($resultdb);
//$file=$linedb[0];
$theCondition=$linedb[1];
$relatedKey=$linedb[2];
$dataTable=$linedb[3];
$measure2 = $linedb[4];
$tableColumns = $linedb[5];
$display=$linedb[6];
$location=$linedb[7];
}
$seeRelated="";
if($relatedKey>0)
{
$queryRelated="select tblRelated.name, tblRelated.value FROM tblRelated where related=".$relatedKey;
$resultRelated=mysql_query($queryRelated);
$seeRelated="";
while(($lineRelated=mysql_fetch_array($resultRelated)))
{
$relatedFile=$lineRelated[0];
$relatedTitle=$lineRelated[1];
$seeRelated=$seeRelated." ".$relatedTitle." "."\n";
}
}
if($location=="europe")
{
$locationCondition=" AND (fb2.value LIKE \"%Europe,%\" OR fb2.name=\"Russia\" OR fb2.name=\"Turkey\") ";
}
if($location=="asia")
{
$locationCondition=" AND (fb2.value LIKE \"%Asia,%\" AND fb2.name!=\"Russia\" AND fb2.name!=\"Turkey\") ";
}
if($location=="africa")
{
$locationCondition=" AND (fb2.value LIKE \"%Africa,%\") ";
}
if($location=="oceania")
{
$locationCondition=" AND (fb2.value LIKE \"%Oceania,%\") ";
}
if($location=="south america")
{
$locationCondition=" AND (fb2.value LIKE \"%South America,%\") ";
}
if($location=="central america")
{
$locationCondition=" AND (fb2.value LIKE \"%Central America,%\") ";
}
if($location=="north america")
{
$locationCondition=" AND (fb2.value LIKE \"%North America,%\" OR fb2.name=\"Mexico\") ";
}
if($location=="middle east")
{
$locationCondition=" AND (fb2.value LIKE \"%Middle East,%\") ";
}
if($location=="caribbean")
{
$locationCondition=" AND (fb2.value LIKE \"%Caribbean,%\") ";
}
if($location=="americas")
{
$locationCondition=" AND (fb2.value LIKE \"%America,%\") ";
}
//include("lr_324/wa2.php");
//$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value tblDataCodes.fips FROM $table, fb0, fbURLs tblDataCodes WHERE (fb0.name=$table.name AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb0.value=\"independent\") order by $table.value $order)";
$query_b=mysql_query("SELECT * from $table LIMIT 1");
$columns = mysql_num_fields($query_b);
for ($i = 0; $i < $columns; $i++) {$field_array[] = mysql_field_name($query_b, $i);}
if($orderby==="value"){$orderby=$table.".value";}
if(!(strpos($measures,"Country")===false) && in_array("name",$field_array) && in_array("value",$field_array))
//if(strpos($measures,"Country")===0 && in_array("name",$field_array) && in_array("value",$field_array))
//if(strpos($table,"fb")===0)
{
// This statement differs from the one below by the condition ($table.value > 0 OR CHAR_LENGTH($table.value)>0 )
//$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND ($table.value > 0 OR CHAR_LENGTH($table.value)>0 )AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order";
$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND ($table.value > 0)AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order";
}
else
{
$columnCheck=true;
$theColumns="";
$arrayOfMeasures=split("--",$measures);
foreach ($arrayOfMeasures as $aMeasure)
{
$theColumns=$theColumns.", ".$aMeasure;
if(!in_array(strtolower($aMeasure), $field_array)){$columnCheck=False;}
}
$theColumns=substr($theColumns,1);
echo"";
if(strlen($tableColumns)>1)
{
$columnCheck=true;
$theColumns=$tableColumns;
}
$orderPhrase="";
if(strlen($orderby)>1)
{
$orderPhrase="order by $orderby $order";
}
if($columnCheck)
{
if(strlen($theCondition)>3)
{
$query1 = "SELECT $theColumns FROM $table where $theCondition $orderPhrase";
}
else
{
$query1 = "SELECT $theColumns FROM $table $orderPhrase";
}
}
else
{
if(strlen($theCondition)>1)
{
$query1 = "SELECT * FROM $table where $theCondition $orderPhrase";
}
else
{
$query1 = "SELECT * FROM $table $orderPhrase";
}
}
}
if($table=="table_expensive_streets")
{
$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips, $table.location FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND $table.value > 0 AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $table.value $order";
}
if($measures=="Population - Muslim and other faiths")
{
$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips, fb70.value FROM $table, fb0, fbURLs, tblDataCodes, fb2, fb70 WHERE (fb0.name=$table.name AND $table.value > 0 AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name AND fb0.name=fb70.name AND (fb70.value LIKE \"Muslim%\" OR fb70.value LIKE \"Sunni%\") ". $dependencyCondition . $locationCondition .") order by $table.value $order";
}
if($measures=="Population - Christian and other faiths")
{
$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips, fb70.value FROM $table, fb0, fbURLs, tblDataCodes, fb2, fb70 WHERE (fb0.name=$table.name AND $table.value > 0 AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name AND fb0.name=fb70.name AND (fb70.value LIKE \"Christian%\" OR fb70.value LIKE \"Roman%\" OR fb70.value LIKE \"Protestant%\" OR fb70.name LIKE \"Nigeria\" ) ". $dependencyCondition . $locationCondition .") order by $table.value $order";
}
define("sql_error_reporting",true);
//result1 = mysql_query($query1) or mail("info@aneki.com", "countries2 error", "Sql error of ".$_SERVER["SCRIPT_NAME"].". Call to `$table` in ".__FILE__." ".$_GET["file"]." on line: ".__LINE__."
".mysql_error()."
SQL:
$query1
"); $result1 = mysql_query($query1); echo""; if($result1) { $decimal='.'; $separator=','; $position=0; $num_rows=0; if($number=="all") { $num_rows = mysql_num_rows($result1); } else { $num_rows = $number; } if($table=="table_expensive_streets") { echo"
";
}
else
{
//echo"
| Country | Capital City |
| Afghanistan | Kabul |
| Albania | Tirana |
| Algeria | Algiers |
| Andorra | Andorra la Vella |
| Angola | Luanda |
| Antigua and Barbuda | Saint John's |
| Argentina | Buenos Aires |
| Armenia | Yerevan |
| Australia | Canberra |
| Austria | Vienna |
| Azerbaijan | Baku (Baki) |
| Bahamas, The | Nassau |
| Bahrain | Manama |
| Bangladesh | Dhaka |
| Barbados | Bridgetown |
| Belarus | Minsk |
| Belgium | Brussels |
| Belize | Belmopan |
| Benin | Porto-Novo is the official capital; Cotonou is the seat of government |
| Bhutan | Thimphu |
| Bolivia | La Paz (seat of government); Sucre (legal capital and seat of judiciary) |
| Bosnia and Herzegovina | Sarajevo |
| Botswana | Gaborone |
| Brazil | Brasilia |
| Brunei | Bandar Seri Begawan |
| Bulgaria | Sofia |
| Burkina Faso | Ouagadougou |
| Burma | Rangoon (regime refers to the capital as Yangon) |
| Burundi | Bujumbura |
| Cambodia | Phnom Penh |
| Cameroon | Yaounde |
| Canada | Ottawa |
| Cape Verde | Praia |
| Central African Republic | Bangui |
| Chad | N'Djamena |
| Chile | Santiago |
| China | Beijing |
| Colombia | Bogota |
| Comoros | Moroni |
| Congo, Democratic Republic of the | Kinshasa |
| Congo, Republic of the | Brazzaville |
| Costa Rica | San Jose |
| Cote d'Ivoire | Yamoussoukro; note - although Yamoussoukro has been the official capital since 1983, Abidjan remains the administrative center; the US, like other countries, maintains its Embassy in Abidjan |
| Croatia | Zagreb |
| Cuba | Havana |
| Cyprus | Nicosia |
| Czech Republic | Prague |
| Denmark | Copenhagen |
| Djibouti | Djibouti |
| Dominica | Roseau |
| Dominican Republic | Santo Domingo |
| East Timor | Dili |
| Ecuador | Quito |
| Egypt | Cairo |
| El Salvador | San Salvador |
| Equatorial Guinea | Malabo |
| Eritrea | Asmara (formerly Asmera) |
| Estonia | Tallinn |
| Ethiopia | Addis Ababa |
| Fiji | Suva |
| Finland | Helsinki |
| France | Paris |
| Gabon | Libreville |
| Gambia, The | Banjul |
| Georgia | T'bilisi |
| Germany | Berlin |
| Ghana | Accra |
| Greece | Athens |
| Grenada | Saint George's |
| Guatemala | Guatemala |
| Guinea | Conakry |
| Guinea-Bissau | Bissau |
| Guyana | Georgetown |
| Haiti | Port-au-Prince |
| Holy See (Vatican City) | Vatican City |
| Honduras | Tegucigalpa |
| Hungary | Budapest |
| Iceland | Reykjavik |
| India | New Delhi |
| Indonesia | Jakarta |
| Iran | Tehran |
| Iraq | Baghdad |
| Ireland | Dublin |
| Israel | Jerusalem; note - Israel proclaimed Jerusalem as its capital in 1950, but the US, like nearly all other countries, maintains its Embassy in Tel Aviv |
| Italy | Rome |
| Jamaica | Kingston |
| Japan | Tokyo |
| Jordan | Amman |
| Kazakhstan | Astana; note - the government moved from Almaty to Astana in December 1998 |
| Kenya | Nairobi |
| Kiribati | Tarawa |
| Korea, North | P'yongyang |
| Korea, South | Seoul |
| Kuwait | Kuwait |
| Kyrgyzstan | Bishkek |
| Laos | Vientiane |
| Latvia | Riga |
| Lebanon | Beirut |
| Lesotho | Maseru |
| Liberia | Monrovia |
| Libya | Tripoli |
| Liechtenstein | Vaduz |
| Lithuania | Vilnius |
| Luxembourg | Luxembourg |
| Macedonia, The Former Yugoslav Republic of | Skopje |
| Madagascar | Antananarivo |
| Malawi | Lilongwe |
| Malaysia | Kuala Lumpur |
| Maldives | Male |
| Mali | Bamako |
| Malta | Valletta |
| Marshall Islands | Majuro |
| Mauritania | Nouakchott |
| Mauritius | Port Louis |
| Mexico | Mexico (Distrito Federal) |
| Micronesia, Federated States of | Palikir |
| Moldova | Chisinau |
| Monaco | Monaco |
| Mongolia | Ulaanbaatar |
| Morocco | Rabat |
| Mozambique | Maputo |
| Namibia | Windhoek |
| Nauru | no official capital; government offices in Yaren District |
| Nepal | Kathmandu |
| Netherlands | Amsterdam; The Hague is the seat of government |
| New Zealand | Wellington |
| Nicaragua | Managua |
| Niger | Niamey |
| Nigeria | Abuja; note - on 12 December 1991 the capital was officially transferred from Lagos to Abuja; most federal government offices have now made the move to Abuja |
| Norway | Oslo |
| Oman | Muscat |
| Pakistan | Islamabad |
| Palau | Koror; note - a new capital is being built about 20 km northeast of Koror |
| Panama | Panama |
| Papua New Guinea | Port Moresby |
| Paraguay | Asuncion |
| Peru | Lima |
| Philippines | Manila |
| Poland | Warsaw |
| Portugal | Lisbon |
| Qatar | Doha |
| Romania | Bucharest |
| Russia | Moscow |
| Rwanda | Kigali |
| Saint Kitts and Nevis | Basseterre |
| Saint Lucia | Castries |
| Saint Vincent and the Grenadines | Kingstown |
| Samoa | Apia |
| San Marino | San Marino |
| Sao Tome and Principe | Sao Tome |
| Saudi Arabia | Riyadh |
| Senegal | Dakar |
| Seychelles | Victoria |
| Sierra Leone | Freetown |
| Singapore | Singapore |
| Slovakia | Bratislava |
| Slovenia | Ljubljana |
| Solomon Islands | Honiara |
| Somalia | Mogadishu |
| South Africa | Pretoria; note - Cape Town is the legislative center and Bloemfontein the judicial center |
| Spain | Madrid |
| Sri Lanka | Colombo; note - Sri Jayewardenepura Kotte is the legislative capital |
| Sudan | Khartoum |
| Suriname | Paramaribo |
| Swaziland | Mbabane; note - Lobamba is the royal and legislative capital |
| Sweden | Stockholm |
| Switzerland | Bern |
| Syria | Damascus |
| Tajikistan | Dushanbe |
| Tanzania | Dar es Salaam; note - legislative offices have been transferred to Dodoma, which is planned as the new national capital; the National Assembly now meets there on regular basis |
| Thailand | Bangkok |
| Togo | Lome |
| Tonga | Nuku'alofa |
| Trinidad and Tobago | Port-of-Spain |
| Tunisia | Tunis |
| Turkey | Ankara |
| Turkmenistan | Ashgabat |
| Tuvalu | Fongafale |
| Uganda | Kampala |
| Ukraine | Kiev (Kyyiv) |
| United Arab Emirates | Abu Dhabi |
| United Kingdom | London |
| United States | Washington, DC |
| Uruguay | Montevideo |
| Uzbekistan | Tashkent (Toshkent) |
| Vanuatu | Port-Vila |
| Venezuela | Caracas |
| Vietnam | Hanoi |
| Yemen | Sanaa |
| Zambia | Lusaka |
| Zimbabwe | Harare |
".mysql_error()."
SQL:
$query1
"); $result1 = mysql_query($query1); echo""; if($result1) { $decimal='.'; $separator=','; $position=0; $num_rows=0; if($number=="all") { $num_rows = mysql_num_rows($result1); } else { $num_rows = $number; } if($table=="table_expensive_streets") { echo"
| Country | Location | Rent (US $/sq.ft/yr) | |
| $position. | $line[3]![](\"https://www.aneki.com/flags/48/".strtolower(trim($line[4]))."-flag.png\") | $line[5] | $unit$theNumber |
| $position | $line[3] | $unit$theNumber |
| "; //echo" | |||||||||||||||||||||||||||||||||
| view as: list / slideshow / map | ||||||||||||||||||||
| view as: list / map | ||||||||||||||||||||
| ▲ | "; $numberOfMeasures=0; foreach ($arrayOfMeasures as $aMeasure) { $aMeasure=urldecode($aMeasure); //echo"$aMeasure | "; if($numberOfMeasures==0) { echo"$aMeasure | "; } else { echo"$aMeasure | "; } $numberOfMeasures=$numberOfMeasures+1; } echo"|||||||||||||||||
| $position. | "; $theRows="||||||||||||||||||||
| $position. | "; //$theRows="||||||||||||||||||||
| $position. | "; for($kl=0;$kl<$numberOfMeasures;$kl++) { $theEntry=$line[$kl]; if(!(strrpos($arrayOfMeasures[$kl],"Height") === FALSE)){$feet=floor($theEntry/12);$inches=$theEntry%12;$theEntry=$feet."-".$inches;} if($arrayOfMeasures[$kl]==="Country" && !(strpos($query1,"fbURLs.value")===false)) //if($arrayOfMeasures[$kl]==="Country" && strpos($measures,"Country")===0) { $theCountryLink=$line[3]; $theCountryLink=str_replace("https://www.aneki.com/","/",$theCountryLink); if(!(strpos($theCountryLink,"
![](\"http://www.masquot.com/flags/48/".strtolower(trim($line[4]))."-flag.png\")
";
$theFlagImage="| $theFlagImage | $theCountryLink |
| $theFlagImage | $theCountryLink |
| $theFlagImage | $theCountryLink |
| $theFlagImage | $theCountryLink |
| $theCountryLink |
$thePrevious single page
isMobile()) { //print" //
// //"; //} //else //{ //print" // //"; //} ?> isMobile()) { include("templates/template_social_sharing_mobile.html"); } else { include("templates/template_social_sharing.html"); } ?> 10) { print"
See Related
-
";
echo"$seeRelated";
}
?>
isMobile()) {
print"
See Also
"; echo"- ";
if($country == "United States")
{
echo"
- US States with the Highest Unemployment Rates
- American States with the Highest Gas Prices
- American Cities with the Highest Gas Prices
- Cities with the Highest Home Prices in America
- US States with the Highest Median Home Income
- US States with the Most Identity Theft Victims
- US States with the Highest Rate of Reported Hate Crimes "; } if($country == "Canada"){ echo "
- Canadian Provinces with the Highest Homicide Rates
- Most Commonly Spoken Languages in Canada
- Most Visited Countries by Canadians
- Canadian Provinces with the Highest Smoking Prevalence
- Canadian Provinces with the Highest Male Life Expectancies
- Canadian Provinces with the Highest Female Life Expectancies
- Canadian Cities with the Highest Cost of Living
- Canadian Provinces with the Heaviest Drinkers
- Canadian Provinces with the Highest Obesity Rates
- Canada's Biggest Exports
- Canadian Provinces with the Highest Gas Prices
- Canadian Cities with the Highest Gas Prices "; } echo"
- Earthquake Prone Countries
- English Speaking Countries
- Happiest Countries
- Most Educated Countries
- Hottest Places in the World
- Socialist Countries
- Population
- Dangerous Countries to Live in
- Oil Producing Countries
- Largest geographical Area
- Cost of Living
- Countries with the largest Oil Reserves
- Least Happy Countries
- Most Corrupt World Leaders
- Best Countries for Gender Equality
- Industrialized Countries receiving the most Asylum Seekers
- Developed Countries
- Countries with the Biggest TV Watchers
- Avalanche Prone Countries
- Developing Countries
- First Countries to send a Man to Space
- Cheapest Countries to Travel to
- Tsunami Prone Countries
- Communist Countries
- World's Best Airports
- Coldest Places in the World
- Busiest Airports in the World
- Members of the G8
- Countries to have won the Most World Cups
- Countries with Nuclear Weapons
- Best Cities
- Spanish Speaking Countries
- Safest Countries for Children
- Countries with the Most Miss Universe Winners
- Highest Mountains in the World
- HIV prevalence
- Countries with the best health care
- Best Countries for Children
- Countries with Women Leaders
- Countries with the Highest Percentage of Women in Parliament
- Countries with the Highest Incidence of Skin Melanoma
- Countries with the Most Olympic Gold Medals
- Highest National Debt
- Countries with the Highest Employment Rates
- Commonly Spoken Languages
- Countries with the Largest Immigrant Populations
- Fastest Growing Tourist Destinations
- Platinum Producing Countries
- Hurricane Prone Countries
- Countries with the Highest Incidence of Breast Cancer
- Longest Serving World Leaders
- Arabic Speaking Countries
- Drought Prone Countries
- Roman Catholic Countries
- Smartest Cities in America
- Portuguese Speaking Countries
- Longest Rivers in the World
- Countries with the Largest Foreign Populations
- Countries that have Monarchies
- Largest Islands in the World
- Highest Illiteracy Rates
- Dangerous Cities
- Italian Speaking Countries
- Most Visited Countries
- Cleanest Cities
- Unemployment
- Military Expenditure
- Most Universities
- Mobile phone users
- Countries with the Largest overweight Populations
- Countries with the Biggest Drinkers
- Worst Cities
- Gold Producing Countries
- Highest Birth Rates
- Worst Countries for Gender Equality
- French Speaking Countries
- Highest Paying Jobs
- Expensive Cities
- Most Populous States in America
- Most Polite Cities in the World
- Cleanest
- Countries with the Highest Quality of Life
- Countries with the Lowest Rate of Deaths from Road Accidents
- Most Dangerous Cities in America
- Newest countries
- European Union Countries
- Highest Teenage Pregnancy Rates in Developed Countries
- Best Cities for Singles in America
- Most Depressing Jobs
- Most Populous Cities in Canada
- Most Generous Countries
- Poorest Countries in the World
- Richest Countries in the World
- Driest Places in the World
- World's Greatest Athletes
- Most Affordable US Cities
- Countries with the Highest Suicide rates
- World's Most Polluted Cities
- Safest Cities in America
- National Holidays
- Most Airports
- Most Googled Countries
- Countries with the Highest Obesity Rates
- World's Most Popular Websites
isMobile()) {
// any mobile platform
}
else
{
include("templates/template_right.html");
}
?>
isMobile()) {
include("templates/template_footer_mobile.html");
}
else
{
include("templates/template_footer.html");
}
?>