";
}
?>
isMobile()) {
print"
";
}
else
{
print"
";
}
?>
isMobile()) {
}
else{
print"
";
include("templates/template_left.html");
print"
";
}
if ($detect->isMobile()) {
print"";
}
else
{
print"
";
}
?>
$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"
- Compare World Cup Countries
- Countries to have Won the Most World Cups
- Non-european World Cup Teams with the Most Players Based in European Clubs
- Countries that have Hosted the Most World Cup Tournaments
- Players with the Most Goals Scored in the World Cup
- Richest Countries of the 2010 World Cup
- Highest Earning Soccer Players
- Most Valuable Soccer Teams
- World cup Countries with the Most Medals Won at the 2008 Beijing Olympics
Five Facts about the World Cup
- A host team has never lost an opening match
- Brazil is the only team to qualify for every single Fifa World Cup tournament
- The average of players at the 2010 Fifa World Cup is 26 years 9 months
- Pele of Brazil is the youngest ever goal scorer at the Fifa World Cup. He scored his first World Cup goal against Wales during the 1958 World Cup at 17 years 239 days
- There are more countries that compete to play in the Fifa world Cup than are members of the United Nations
".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");
}
?>