Error: [$errno] $errstr on line $error_line in file $aFile -- $error_file -- $error_context -- referrer - $theAnekiReferrer" ); } $t="National Holidays"; $table=""; $places=""; $decimals=""; $unit=""; $orderby=""; $order=""; $order_opposite=""; if($order==="asc"){$order_opposite="desc";} if($order==="desc"){$order_opposite="asc";} $dependency="independent"; $number="10"; $cntdn="n"; $r="seeRelated"; $measures=""; $units=""; $file="holidays"; $c=""; $map=""; $mapData=""; $mapCode=""; $seeRelated=""; //if(isset($_GET["t"])){$t=$_GET["t"];} //if(isset($_GET["table"])){$table=$_GET["table"];} //if(isset($_GET["places"])){$places=$_GET["places"];} //if(isset($_GET["decimals"])){$decimals=$_GET["decimals"];} //if(isset($_GET["unit"])){$unit=$_GET["unit"];} if(isset($_GET["orderby"])){$orderby=$_GET["orderby"];} if(isset($_GET["order"])){$order=$_GET["order"]; if($order==="asc"){$order_opposite="desc";}if($order==="desc"){$order_opposite="asc";}} if(isset($_GET["dependency"])){$dependency=$_GET["dependency"];} if(isset($_GET["number"])){$number=$_GET["number"];} if(isset($_GET["cntdn"])){$cntdn=$_GET["cntdn"];} if(isset($_GET["r"])){$r=$_GET["r"];} if(isset($_GET["measures"])){$measures=$_GET["measures"];} if(isset($_GET["units"])){$units=$_GET["units"];} //if(isset($_GET["file"])){$file=$_GET["file"];} if(isset($_GET["c"])){$c=$_GET["c"];} if(isset($_GET["map"])){$map=$_GET["map"];} if($table!="") { include("lr_324/wa2.php"); mysql_set_charset('utf8', $link); } if($number=="all") { $theNumber=""; } else { $theNumber=$number; } $theLocation=" in the World"; if($c=="europe") { $theLocation=" in Europe"; } if($c=="africa") { $theLocation=" in Africa"; } if($c=="asia") { $theLocation=" in Asia"; } if($c=="middle east") { $theLocation=" in the Middle East"; } if($c=="oceania") { $theLocation=" in Oceania"; } if($c=="caribbean") { $theLocation=" in the Caribbean"; } if($c=="south america") { $theLocation=" in South America"; } if($c=="central america") { $theLocation=" in Central America"; } if($c=="north america") { $theLocation=" in North America"; } $theTitle=str_replace("_"," ",$t); if($order=="desc") { if($theNumber==""){$theTitle="List of ".$theTitle;} else{ $containsTop = strrpos($theTitle,"Top"); if($containsTop===false){$theTitle="Top $theNumber ".$theTitle;} else{$theTitle="$theNumber ".$theTitle;} } $theDescription="List ranking the ".$theTitle." compiled by Aneki.com"; $theKeywords="top, countries, list, rank, order, world".str_replace("_",", ",$t).",".$dependency.".".$c; } else { $theTitle="List of ".str_replace("_"," ",$t); $theDescription="List ranking the ".str_replace("_"," ",$t)." compiled by Aneki.com"; $theKeywords="countries, list, rank, order, world, ".str_replace("_",", ",$t); } $arrayOfMeasures=explode("--",$measures); $units=str_replace("*","",$units); $arrayOfUnits=explode("--",$units); $decimals=str_replace("*","",$decimals); $arrayOfDecimals=explode("--",$decimals); $dependencyCondition=""; if($dependency=="none") { $dependencyCondition=" "; } else { $dependencyCondition=" AND (fb0.value=\"$dependency\")"; } $locationCondition=""; if($c=="europe") { $locationCondition=" AND (fb2.value LIKE \"%Europe,%\" OR fb2.name=\"Russia\" OR fb2.name=\"Turkey\") "; } if($c=="asia") { $locationCondition=" AND (fb2.value LIKE \"%Asia,%\" AND fb2.name!=\"Russia\" AND fb2.name!=\"Turkey\") "; } if($c=="africa") { $locationCondition=" AND (fb2.value LIKE \"%Africa,%\") "; } if($c=="oceania") { $locationCondition=" AND (fb2.value LIKE \"%Oceania,%\") "; } if($c=="south america") { $locationCondition=" AND (fb2.value LIKE \"%South America,%\") "; } if($c=="central america") { $locationCondition=" AND (fb2.value LIKE \"%Central America,%\") "; } if($c=="north america") { $locationCondition=" AND (fb2.value LIKE \"%North America,%\" OR fb2.name=\"Mexico\") "; } if($c=="middle east") { $locationCondition=" AND (fb2.value LIKE \"%Middle East,%\") "; } if($c=="caribbean") { $locationCondition=" AND (fb2.value LIKE \"%Caribbean,%\") "; } if($c=="americas") { $locationCondition=" AND (fb2.value LIKE \"%America,%\") "; } if($c=="asiapacific") { $locationCondition=" AND (fb2.value LIKE \"%Asia,%\" or fb2.value LIKE \"%Oceania,%\") "; } //if(strlen($orderby)<1) //{ //$orderby=$table.".value"; //$query_schema="SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = '$table' AND ORDINAL_POSITION =1"; //$result_schema=mysql_query($query_schema); //if($result_schema) //{ //while ($line = mysql_fetch_array($result_schema)) //{ //$orderby=$line[0]; //} //} //} if($map=="on") { $query_for_map = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.iso 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"; //$query_for_map = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (($table.value > 0)AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order"; $result_for_map = mysql_query($query_for_map);// 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:
$query_for_map
"); if(!$result_for_map) { $query_for_map = "SELECT $table.country, $table.value, fb0.value, fbURLs.value, tblDataCodes.iso FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.country 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"; $result_for_map = mysql_query($query_for_map);// 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:
$query_for_map
"); } if($result_for_map && count($arrayOfMeasures)>1) { $num_rows = mysql_num_rows($result_for_map); $countryCount=0; while ($line = mysql_fetch_array($result_for_map)) { $theName=$line[4]; $theValue=$line[1]; if($theName=="Congo, Democratic Republic of the"){$theName="Congo, the Democratic Republic of the";} if($theName=="Cote d'Ivoire"){$theName="Côte d'Ivoire";} if(!strpos($theName,"'")) { $mapData=$mapData."data.setValue($countryCount, 0, '$theName');"; $mapData=$mapData."data.setValue($countryCount, 1, $theValue);"; } else { $mapData=$mapData."data.setValue($countryCount, 0, '".str_replace("'",""",$theName)."');"; $mapData=$mapData."data.setValue($countryCount, 1, $theValue);"; } $countryCount=$countryCount+1; } //} //$mapColors="0xD0E3F8, 0x0066ff, 0x0000ff"; $mapColors="0xD0E3F8, 0xbbbbbb, 0x0000ff"; if($order=="asc") { //$mapColors="0x0000ff, 0xD0E3F8, 0x0066ff"; $mapColors="0x0000ff, 0xD0E3F8, 0xbbbbbb"; } $mapCode="
"; } } ?> National Holidays isMobile()) { print" "; } else { print" "; } ?> isMobile()) { include("templates/template_top_mobile_3.html"); } else { include("templates/template_top.html"); } ?> isMobile()) { print"
"; } else { print"
"; } ?>
isMobile()) { print"
"; } else { print"
"; } ?>
isMobile()) { } else{ print"
"; include("templates/template_left.html"); print"
"; } if ($detect->isMobile()) { print"
"; } else { print"
"; } ?>
CountryNational Holiday
AfghanistanIndependence Day, 19 August (1919)
AlbaniaIndependence Day, 28 November (1912)
AlgeriaRevolution Day, 1 November (1954)
AndorraOur Lady of Meritxell Day, 8 September (1278)
AngolaIndependence Day, 11 November (1975)
Antigua and BarbudaIndependence Day (National Day), 1 November (1981)
ArgentinaRevolution Day, 25 May (1810)
ArmeniaIndependence Day, 21 September (1991)
AustraliaAustralia Day, 26 January (1788)
AustriaNational Day, 26 October (1955); note - commemorates the State Treaty restoring national sovereignty and the end of occupation and the passage of the law on permanent neutrality
AzerbaijanFounding of the Democratic Republic of Azerbaidzhan, 28 May (1918)
Bahamas, TheIndependence Day, 10 July (1973)
BahrainNational Day, 16 December (1971); note - 15 August 1971 is the date of independence from the UK, 16 December 1971 is the date of independence from British protection
BangladeshIndependence Day, 26 March (1971); note - 26 March 1971 is the date of independence from West Pakistan, 16 December 1971 is Victory Day and commemorates the official creation of the state of Bangladesh
BarbadosIndependence Day, 30 November (1966)
BelarusIndependence Day, 3 July (1944); note - 3 July 1944 was the date Minsk was liberated from German troops, 25 August 1991 was the date of independence from the Soviet Union
BelgiumIndependence Day, 21 July (1831)
BelizeIndependence Day, 21 September (1981)
BeninNational Day, 1 August (1960)
BhutanNational Day (Ugyen WANGCHUCK became first hereditary king), 17 December (1907)
BoliviaIndependence Day, 6 August (1825)
Bosnia and HerzegovinaNational Day, 25 November (1943)
BotswanaIndependence Day (Botswana Day), 30 September (1966)
BrazilIndependence Day, 7 September (1822)
BruneiNational Day, 23 February (1984); note - 1 January 1984 was the date of independence from the UK, 23 February 1984 was the date of independence from British protection
BulgariaLiberation Day, 3 March (1878)
Burkina FasoRepublic Day, 11 December (1958)
BurmaIndependence Day, 4 January (1948)
BurundiIndependence Day, 1 July (1962)
CambodiaIndependence Day, 9 November (1953)
CameroonRepublic Day (National Day), 20 May (1972)
CanadaCanada Day, 1 July (1867)
Cape VerdeIndependence Day, 5 July (1975)
Central African RepublicRepublic Day, 1 December (1958)
ChadIndependence Day, 11 August (1960)
ChileIndependence Day, 18 September (1810)
ChinaAnniversary of the Founding of the People's Republic of China, 1 October (1949)
ColombiaIndependence Day, 20 July (1810)
ComorosIndependence Day, 6 July (1975)
Congo, Democratic Republic of theIndependence Day, 30 June (1960)
Congo, Republic of theIndependence Day, 15 August (1960)
Costa RicaIndependence Day, 15 September (1821)
Cote d'IvoireIndependence Day, 7 August (1960)
CroatiaStatehood Day, 25 June (1991)
CubaIndependence Day, 10 December (1898); note - 10 December 1898 is the date of independence from Spain, 20 May 1902 is the date of independence from US administration
CyprusIndependence Day, 1 October (1960); note - Turkish Cypriot area celebrates 15 November (1983) as Independence Day
Czech RepublicCzech Founding Day, 28 October (1918)
Denmarknone designated; Constitution Day, 5 June is generally viewed as the National Day
DjiboutiIndependence Day, 27 June (1977)
DominicaIndependence Day, 3 November (1978)
Dominican RepublicIndependence Day, 27 February (1844)
East TimorIndependence Day, 28 November (1975)
EcuadorIndependence Day (independence of Quito), 10 August (1809)
EgyptRevolution Day, 23 July (1952)
El SalvadorIndependence Day, 15 September (1821)
Equatorial GuineaIndependence Day, 12 October (1968)
EritreaIndependence Day, 24 May (1993)
EstoniaIndependence Day, 24 February (1918); note - 24 February 1918 was the date of independence from Soviet Russia, 20 August 1991 was the date of reindependence from the Soviet Union
EthiopiaNational Day (defeat of MENGISTU regime), 28 May (1991)
FijiIndependence Day, second Monday of October (1970)
FinlandIndependence Day, 6 December (1917)
FranceBastille Day, 14 July (1789)
GabonFounding of the Gabonese Democratic Party (PDG), 12 March (1968)
Gambia, TheIndependence Day, 18 February (1965)
GeorgiaIndependence Day, 26 May (1918); note - 26 May 1918 is the date of independence from Soviet Russia, 9 April 1991 is the date of independence from the Soviet Union
GermanyUnity Day, 3 October (1990)
GhanaIndependence Day, 6 March (1957)
GreeceIndependence Day, 25 March (1821)
GrenadaIndependence Day, 7 February (1974)
GuatemalaIndependence Day, 15 September (1821)
GuineaIndependence Day, 2 October (1958)
Guinea-BissauIndependence Day, 24 September (1973)
GuyanaRepublic Day, 23 February (1970)
HaitiIndependence Day, 1 January (1804)
Holy See (Vatican City)Coronation Day of Pope JOHN PAUL II, 22 October (1978)
HondurasIndependence Day, 15 September (1821)
HungarySt. Stephen's Day, 20 August
IcelandIndependence Day, 17 June (1944)
IndiaRepublic Day, 26 January (1950)
IndonesiaIndependence Day, 17 August (1945)
IranRepublic Day, 1 April (1979)
IraqRevolution Day, 17 July (1968)
IrelandSaint Patrick's Day, 17 March
IsraelIndependence Day, 14 May (1948); note - Israel declared independence on 14 May 1948, but the Jewish calendar is lunar and the holiday may occur in April or May
ItalyRepublic Day, 2 June (1946)
JamaicaIndependence Day, first Monday in August (1962)
JapanBirthday of Emperor AKIHITO, 23 December (1933)
JordanIndependence Day, 25 May (1946)
KazakhstanRepublic Day, 25 October (1990)
KenyaIndependence Day, 12 December (1963)
KiribatiIndependence Day, 12 July (1979)
Korea, NorthFounding of the Democratic People's Republic of Korea (DPRK), 9 September (1948)
Korea, SouthLiberation Day, 15 August (1945)
KuwaitNational Day, 25 February (1950)
KyrgyzstanIndependence Day, 31 August (1991)
LaosRepublic Day, 2 December (1975)
LatviaIndependence Day, 18 November (1918); note - 18 November 1918 is the date of independence from Soviet Russia, 21 August 1991 is the date of independence from the Soviet Union
LebanonIndependence Day, 22 November (1943)
LesothoIndependence Day, 4 October (1966)
LiberiaIndependence Day, 26 July (1847)
LibyaRevolution Day, 1 September (1969)
LiechtensteinAssumption Day, 15 August
LithuaniaIndependence Day, 16 February (1918); note - 16 February 1918 is the date of independence from German, Austrian, Prussian, and Russian occupation, 11 March 1990 is the date of independence from the Soviet Union
LuxembourgNational Day (Birthday of Grand Duchess Charlotte) 23 June
Macedonia, The Former Yugoslav Republic ofUprising Day, 2 August (1903)
MadagascarIndependence Day, 26 June (1960)
MalawiIndependence Day (Republic Day), 6 July (1964)
MalaysiaIndependence Day/Malaysia Day, 31 August (1957)
MaldivesIndependence Day, 26 July (1965)
MaliIndependence Day, 22 September (1960)
MaltaIndependence Day, 21 September (1964)
Marshall IslandsConstitution Day, 1 May (1979)
MauritaniaIndependence Day, 28 November (1960)
MauritiusIndependence Day, 12 March (1968)
MexicoIndependence Day, 16 September (1810)
Micronesia, Federated States ofConstitution Day, 10 May (1979)
MoldovaIndependence Day, 27 August (1991)
MonacoNational Day (Prince of Monaco Holiday), 19 November
MongoliaIndependence Day/Revolution Day, 11 July (1921)
MoroccoThrone Day (accession of King MOHAMED VI to the throne), 30 July (1999)
MozambiqueIndependence Day, 25 June (1975)
NamibiaIndependence Day, 21 March (1990)
NauruIndependence Day, 31 January (1968)
NepalBirthday of King GYANENDRA, 7 July (1946)
NetherlandsQueen's Day (Birthday of Queen-Mother JULIANA in 1909 and accession to the throne of her oldest daughter BEATRIX in 1980), 30 April
New ZealandWaitangi Day (Treaty of Waitangi established British sovereignty over New Zealand), 6 February (1840)
NicaraguaIndependence Day, 15 September (1821)
NigerRepublic Day, 18 December (1958)
NigeriaIndependence Day (National Day), 1 October (1960)
NorwayConstitution Day, 17 May (1814); note - on 14 January 1814 Denmark ceded Norway to Sweden; resisting Swedish domination, Norwegians adopted a new constitution four months later; on 14 August 1814 Norway was proclaimed independent but in union with Sweden; on 7 June 1905 Norway declared the union with Sweden dissolved
OmanBirthday of Sultan QABOOS, 18 November (1940)
PakistanRepublic Day, 23 March (1956)
PalauConstitution Day, 9 July (1979)
PanamaIndependence Day, 3 November (1903)
Papua New GuineaIndependence Day, 16 September (1975)
ParaguayIndependence Day, 14 May (1811)
PeruIndependence Day, 28 July (1821)
PhilippinesIndependence Day (from Spain), 12 June (1898); note - 12 June 1898 is the date of independence from Spain, 4 July 1946 is the date of independence from the US
PolandConstitution Day, 3 May (1791)
PortugalPortugal Day, 10 June (1580)
QatarIndependence Day, 3 September (1971)
RomaniaUnification Day (of Romania and Transylvania), 1 December (1918)
RussiaRussia Day, 12 June (1990)
RwandaIndependence Day, 1 July (1962)
Saint Kitts and NevisIndependence Day, 19 September (1983)
Saint LuciaIndependence Day, 22 February (1979)
Saint Vincent and the GrenadinesIndependence Day, 27 October (1979)
SamoaIndependence Day Celebration, 1 June (1962); note - 1 January 1962 is the date of independence from the New Zealand-administered UN trusteeship, 1 June 1962 is the date that independence is celebrated
San MarinoFounding of the Republic, 3 September (301)
Sao Tome and PrincipeIndependence Day, 12 July (1975)
Saudi ArabiaUnification of the Kingdom, 23 September (1932)
SenegalIndependence Day, 4 April (1960)
SeychellesConstitution Day (National Day), 18 June (1993)
Sierra LeoneIndependence Day, 27 April (1961)
SingaporeIndependence Day, 9 August (1965)
SlovakiaConstitution Day, 1 September (1992)
SloveniaIndependence Day/Statehood Day, 25 June (1991)
Solomon IslandsIndependence Day, 7 July (1978)
SomaliaFoundation of the Somali Republic, 1 July (1960); note - 26 June (1960) in Somaliland
South AfricaFreedom Day, 27 April (1994)
SpainHispanic Day, 12 October
Sri LankaIndependence Day, 4 February (1948)
SudanIndependence Day, 1 January (1956)
SurinameIndependence Day, 25 November (1975)
SwazilandIndependence Day, 6 September (1968)
SwedenFlag Day, 6 June
SwitzerlandFounding of the Swiss Confederation, 1 August (1291)
SyriaIndependence Day, 17 April (1946)
TajikistanIndependence Day (or National Day), 9 September (1991)
TanzaniaUnion Day (Tanganyika and Zanzibar), 26 April (1964)
ThailandBirthday of King PHUMIPHON, 5 December (1927)
TogoIndependence Day, 27 April (1960)
TongaIndependence Day, 4 June (1970)
Trinidad and TobagoIndependence Day, 31 August (1962)
TunisiaIndependence Day, 20 March (1956)
TurkeyIndependence Day, 29 October (1923)
TurkmenistanIndependence Day, 27 October (1991)
TuvaluIndependence Day, 1 October (1978)
UgandaIndependence Day, 9 October (1962)
UkraineIndependence Day, 24 August (1991)
United Arab EmiratesIndependence Day, 2 December (1971)
United KingdomBirthday of Queen ELIZABETH II, celebrated on the second Saturday in June (1926)
United StatesIndependence Day, 4 July (1776)
UruguayIndependence Day, 25 August (1825)
UzbekistanIndependence Day, 1 September (1991)
VanuatuIndependence Day, 30 July (1980)
VenezuelaIndependence Day, 5 July (1811)
VietnamIndependence Day, 2 September (1945)
YemenUnification Day, 22 May (1990)
ZambiaIndependence Day, 24 October (1964)
ZimbabweIndependence Day, 18 April (1980)
"; $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""; $theRows=""; while (($line = mysql_fetch_array($result1)) && ($position<$num_rows) ) { $position=$position+1; $modulus=($position%2)+1; $theNumber=number_format($line[1],$places,$decimal,$separator); //$countryLink=str_replace("http://www.aneki.com/","/",$line[5]); if($cntdn=="y") { $theRows="".$theRows; } else { $theRows=$theRows.""; } } echo"$theRows"; echo"
     CountryLocationRent (US $/sq.ft/yr)
    $position.$line[3]
    $line[5]$unit$theNumber
    $position$line[3]$unit$theNumber
    "; } else { //echo"
    "; //echo"
     
    "; //echo"
    view as: list / slideshow / map
    "; if(strrpos($display,"slide")===false) { echo"
    view as: list / map
    "; echo"
    view as: list / map
    "; if($map=="on") { print"$mapCode"; } echo""; $numberOfMeasures=0; foreach ($arrayOfMeasures as $aMeasure) { $aMeasure=urldecode($aMeasure); //echo""; if($numberOfMeasures==0) { echo""; } else { echo""; } $numberOfMeasures=$numberOfMeasures+1; } echo""; $theRows=""; $theTable=""; while (($line = mysql_fetch_array($result1)) && ($position<$num_rows) ) { $position=$position+1; $modulus=($position%2)+1; $theNumber=number_format($line[1],$places,$decimal,$separator); //$theRows=""; $theRows=""; //$theRows=""; 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,""; $theFlagImage=""; //$theFlagImage=""; //$theEntry="
    $aMeasure$aMeasure$aMeasure
    $position.
    $position.
    $position.
    $theFlagImage
    $theCountryLink
    "; //$theEntry="
    $theFlagImage$theCountryLink
    "; //$theEntry="
    $theFlagImage
    $theCountryLink
    "; //$theEntry="
    $theFlagImage$theCountryLink
    "; $theEntry="
    $theCountryLink
    "; } } if(isset($arrayOfDecimals[$kl]) && !($arrayOfMeasures[$kl]==="Year")) { if($arrayOfDecimals[$kl]==="" && is_numeric($theEntry)) { $theEntry=number_format($theEntry,0); } else if(!($arrayOfDecimals[$kl]==="") && is_numeric($theEntry)) { $theEntry=number_format($theEntry,$arrayOfDecimals[$kl]); } } if(isset($arrayOfUnits[$kl])) { if($kl===0) { //$theRows=$theRows."$arrayOfUnits[$kl]$theEntry "; $theUnit=rawurldecode($arrayOfUnits[$kl]); $theRows=$theRows."$theUnit$theEntry "; //$theRows=$theRows."$arrayOfUnits[$kl]$theEntry "; } if($kl>0) { $theUnit=rawurldecode($arrayOfUnits[$kl]); //$theRows=$theRows."$arrayOfUnits[$kl]$theEntry "; $theRows=$theRows."$theUnit$theEntry "; //$theRows=$theRows."$arrayOfUnits[$kl]$theEntry "; } } } if($cntdn=="y") { $theTable=$theRows.$theTable; } else { $theTable=$theTable.$theRows; } } $selected10=""; $selected25=""; $selected50=""; $selected100=""; $selectedAll=""; if($number==="10"){$selected10="SELECTED";} if($number==="25"){$selected25="SELECTED";} if($number==="50"){$selected50="SELECTED";} if($number==="100"){$selected100="SELECTED";} if($number==="all"){$selectedAll="SELECTED";} $selectForm="
    "; $theTable=$theTable."$selectForm"; if($number==5) { $thePrevious=""; if($file!="") { $thePrevious=" Previous  |  6 -10 | 1- 5 | "; } $theTable=$theTable."

    $thePrevious single page

    "; } if(!strrpos($display,"slide")) { echo"$theTable"; echo""; } } } } } } mysql_close($link); } ?>
    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"
    "; } else { //begin detecting geo location function Dot2LongIP ($IPaddr) { if ($IPaddr == "") { return 0; } else { $ips = split ("\.", "$IPaddr"); return ($ips[3] + $ips[2] * 256 + $ips[1] * 65536 + $ips[0] *16777216); } } $ipnum= Dot2LongIp(getenv('REMOTE_ADDR') ); include("lr_324/wa3.php"); $query= "SELECT cn FROM geoip WHERE $ipnum >= start AND $ipnum <= end"; $result = mysql_query($query); $country=""; while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $country = $row['cn']; } //end detecting geo location echo"

    See Also

    "; echo""; mysql_close($link); print" "; } ?>


    isMobile()) { // any mobile platform } else { include("templates/template_right.html"); } ?>
    isMobile()) { include("templates/template_footer_mobile.html"); } else { include("templates/template_footer.html"); } ?>