Error: [$errno] $errstr on line $error_line in file $aFile -- $error_file -- $error_context -- referrer - $theAnekiReferrer" ); } $t="World Currencies"; $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="currencies"; $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="
"; } } ?> World Currencies 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"
"; } ?>
CountryCurrency
Afghanistanafghani (AFA)
Albanialek (ALL)
AlgeriaAlgerian dinar (DZD)
Andorraeuro (EUR); French franc (FRF); Spanish peseta (ESP)
Angolakwanza (AOA)
Antigua and BarbudaEast Caribbean dollar (XCD)
ArgentinaArgentine peso (ARS)
Armeniadram (AMD)
AustraliaAustralian dollar (AUD)
Austriaeuro (EUR); Austrian schilling (ATS)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by the financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
AzerbaijanAzerbaijani manat (AZM)
Bahamas, TheBahamian dollar (BSD)
BahrainBahraini dinar (BHD)
Bangladeshtaka (BDT)
BarbadosBarbadian dollar (BBD)
BelarusBelarusian ruble (BYB/BYR)
Belgiumeuro (EUR); Belgian franc (BEF)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
BelizeBelizean dollar (BZD)
BeninCommunaute Financiere Africaine franc (XOF); note - responsible authority is the Central Bank of the West African States
Bhutanngultrum (BTN); Indian rupee (INR)
Boliviaboliviano (BOB)
Bosnia and Herzegovinamarka (BAM)
Botswanapula (BWP)
Brazilreal (BRL)
BruneiBruneian dollar (BND)
Bulgarialev (BGL)
Burkina FasoCommunaute Financiere Africaine franc (XOF); note - responsible authority is the Central Bank of the West African States
Burmakyat (MMK)
BurundiBurundi franc (BIF)
Cambodiariel (KHR)
CameroonCommunaute Financiere Africaine franc (XAF); note - responsible authority is the Bank of the Central African States
CanadaCanadian dollar (CAD)
Cape VerdeCape Verdean escudo (CVE)
Central African RepublicCommunaute Financiere Africaine franc (XAF); note - responsible authority is the Bank of the Central African States
ChadCommunaute Financiere Africaine franc (XAF); note - responsible authority is the Bank of the Central African States
ChileChilean peso (CLP)
Chinayuan (CNY)
ColombiaColombian peso (COP)
ComorosComoran franc (KMF)
Congo, Democratic Republic of theCongolese franc (CDF)
Congo, Republic of theCommunaute Financiere Africaine franc (XAF); note - responsible authority is the Bank of the Central African States
Costa RicaCosta Rican colon (CRC)
Cote d'IvoireCommunaute Financiere Africaine franc (XOF); note - responsible authority is the Central Bank of the West African States
Croatiakuna (HRK)
CubaCuban peso (CUP)
CyprusGreek Cypriot area: Cypriot pound (CYP); Turkish Cypriot area: Turkish lira (TRL)
Czech RepublicCzech koruna (CZK)
DenmarkDanish krone (DKK)
DjiboutiDjiboutian franc (DJF)
DominicaEast Caribbean dollar (XCD)
Dominican RepublicDominican peso (DOP)
East TimorUS dollar (USD)
EcuadorUS dollar (USD)
EgyptEgyptian pound (EGP)
El SalvadorSalvadoran colon (SVC); US dollar (USD)
Equatorial GuineaCommunaute Financiere Africaine franc (XAF); note - responsible authority is the Bank of the Central African States
Eritreanakfa (ERN)
EstoniaEstonian kroon (EEK)
Ethiopiabirr (ETB)
FijiFijian dollar (FJD)
Finlandmarkka (FIM); euro (EUR)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
Franceeuro (EUR); French franc (FRF)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
GabonCommunaute Financiere Africaine franc (XAF); note - responsible authority is the Bank of the Central African States
Gambia, Thedalasi (GMD)
Georgialari (GEL)
Germanyeuro (EUR); deutsche mark (DEM)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
Ghanacedi (GHC)
Greeceeuro (EUR); drachma (GRD)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
GrenadaEast Caribbean dollar (XCD)
Guatemalaquetzal (GTQ), US dollar (USD), others allowed
GuineaGuinean franc (GNF)
Guinea-BissauCommunaute Financiere Africaine franc (XOF); note - responsible authority is the Central Bank of the West African States; previously the Guinea-Bissau peso (GWP) was used
GuyanaGuyanese dollar (GYD)
Haitigourde (HTG)
Holy See (Vatican City)euro (EUR); Italian lira (ITL)
Honduraslempira (HNL)
Hungaryforint (HUF)
IcelandIcelandic krona (ISK)
IndiaIndian rupee (INR)
IndonesiaIndonesian rupiah (IDR)
IranIranian rial (IRR)
IraqIraqi dinar (IQD)
Irelandeuro (EUR); Irish pound (IEP)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
Israelnew Israeli shekel (ILS)
Italyeuro (EUR); Italian lira (ITL)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
JamaicaJamaican dollar (JMD)
Japanyen (JPY)
JordanJordanian dinar (JOD)
Kazakhstantenge (KZT)
KenyaKenyan shilling (KES)
KiribatiAustralian dollar (AUD)
Korea, NorthNorth Korean won (KPW)
Korea, SouthSouth Korean won (KRW)
KuwaitKuwaiti dinar (KD)
KyrgyzstanKyrgyzstani som (KGS)
Laoskip (LAK)
LatviaLatvian lat (LVL)
LebanonLebanese pound (LBP)
Lesotholoti (LSL); South African rand (ZAR)
LiberiaLiberian dollar (LRD)
LibyaLibyan dinar (LYD)
LiechtensteinSwiss franc (CHF)
Lithuanialitas (LTL)
Luxembourgeuro (EUR); Luxembourg franc (LUF)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
Macedonia, The Former Yugoslav Republic ofMacedonian denar (MKD)
MadagascarMalagasy franc (MGF)
MalawiMalawian kwacha (MWK)
Malaysiaringgit (MYR)
Maldivesrufiyaa (MVR)
MaliCommunaute Financiere Africaine franc (XOF); note - responsible authority is the Central Bank of the West African States
MaltaMaltese lira (MTL)
Marshall IslandsUS dollar (USD)
Mauritaniaouguiya (MRO)
MauritiusMauritian rupee (MUR)
MexicoMexican peso (MXN)
Micronesia, Federated States ofUS dollar (USD)
MoldovaMoldovan leu (MDL)
Monacoeuro (EUR); French franc (FRF)
Mongoliatogrog/tugrik (MNT)
MoroccoMoroccan dirham (MAD)
Mozambiquemetical (MZM)
NamibiaNamibian dollar (NAD); South African rand (ZAR)
NauruAustralian dollar (AUD)
NepalNepalese rupee (NPR)
Netherlandseuro (EUR); Netherlands guilder (NLG)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
New ZealandNew Zealand dollar (NZD)
Nicaraguagold cordoba (NIO)
NigerCommunaute Financiere Africaine franc (XOF); note - responsible authority is the Central Bank of the West African States
Nigerianaira (NGN)
NorwayNorwegian krone (NOK)
OmanOmani rial (OMR)
PakistanPakistani rupee (PKR)
PalauUS dollar (USD)
Panamabalboa (PAB); US dollar (USD)
Papua New Guineakina (PGK)
Paraguayguarani (PYG)
Perunuevo sol (PEN)
PhilippinesPhilippine peso (PHP)
Polandzloty (PLN)
Portugaleuro (EUR); Portuguese escudo (PTE)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions within the member countries
QatarQatari rial (QAR)
Romanialeu (ROL)
RussiaRussian ruble (RUR)
RwandaRwandan franc (RWF)
Saint Kitts and NevisEast Caribbean dollar (XCD)
Saint LuciaEast Caribbean dollar (XCD)
Saint Vincent and the GrenadinesEast Caribbean dollar (XCD)
Samoatala (WST)
San Marinoeuro (EUR); Italian lira (ITL)
Sao Tome and Principedobra (STD)
Saudi ArabiaSaudi riyal (SAR)
SenegalCommunaute Financiere Africaine franc (XOF); note - responsible authority is the Central Bank of the West African States
SeychellesSeychelles rupee (SCR)
Sierra Leoneleone (SLL)
SingaporeSingapore dollar (SGD)
SlovakiaSlovak koruna (SKK)
Sloveniatolar (SIT)
Solomon IslandsSolomon Islands dollar (SBD)
SomaliaSomali shilling (SOS)
South Africarand (ZAR)
Spaineuro (EUR); Spanish peseta (ESP)
note: on 1 January 1999, the European Monetary Union introduced the euro as a common currency to be used by the financial institutions of member countries; on 1 January 2002, the euro became the sole currency for everyday transactions with the member countries
Sri LankaSri Lankan rupee (LKR)
SudanSudanese dinar (SDD)
SurinameSurinamese guilder (SRG)
Swazilandlilangeni (SZL)
SwedenSwedish krona (SEK)
SwitzerlandSwiss franc (CHF)
SyriaSyrian pound (SYP)
Tajikistansomoni
TanzaniaTanzanian shilling (TZS)
Thailandbaht (THB)
TogoCommunaute Financiere Africaine franc (XOF); note - responsible authority is the Central Bank of the West African States
Tongapa'anga (TOP)
Trinidad and TobagoTrinidad and Tobago dollar (TTD)
TunisiaTunisian dinar (TND)
TurkeyTurkish lira (TRL)
TurkmenistanTurkmen manat (TMM)
TuvaluAustralian dollar (AUD); note - there is also a Tuvaluan dollar
UgandaUgandan shilling (UGX)
Ukrainehryvnia (UAH)
United Arab EmiratesEmirati dirham (AED)
United KingdomBritish pound (GBP)
United StatesUS dollar (USD)
UruguayUruguayan peso (UYU)
UzbekistanUzbekistani sum (UZS)
Vanuatuvatu (VUV)
Venezuelabolivar (VEB)
Vietnamdong (VND)
YemenYemeni rial (YER)
ZambiaZambian kwacha (ZMK)
ZimbabweZimbabwean dollar (ZWD)
"; $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"); } ?>