";
}
?>
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"
| 1 | Austria | |
| 2 | Azerbaijan | |
| 3 | Bulgaria | |
| 4 | Cambodia | |
| 5 | Cameroon | |
| 6 | China | |
| 7 | Croatia | |
| 8 | Cyprus | |
| 9 | Egypt | |
| 10 | France | |
| 11 | Germany | |
| 12 | Greece | |
| 13 | Hungary | |
| 14 | India | |
| 15 | Indonesia | |
| 16 | Iran | |
| 17 | Iraq | |
| 18 | Italy | |
| 19 | Japan | |
| 20 | Kazakhstan | |
| 21 | Kuwait | |
| 22 | Laos | |
| 23 | Malaysia | |
| 24 | Mongolia | |
| 25 | Niger | |
| 26 | Nigeria | |
| 27 | Poland | |
| 28 | Romania | |
| 29 | Russia | |
| 30 | Slovakia | |
| 31 | Slovenia | |
| 32 | Switzerland | |
| 33 | Korea, South | |
| 34 | Thailand | |
| 35 | Turkey | |
| 36 | Ukraine | |
| 37 | United Kingdom | |
| 38 | Vietnam | |
| Source: FAO/WHO | ||
".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");
}
?>