";
}
?>
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"
| Hours after the space shuttle disentegrated over Texas, news of the tragedy reached millions of people via the World Wide Web, cable, and catelite television. Ironically, some of the astronauts aboard the ill fated Columbia were trained to deploy communications satelites - the very same type that would later beam the news of their demise around the world. For many old enough to remember, the news harkened back memories of the only other fatal shuttle accident that ever took place - the explosion of the space shuttle challenger shortly after lift off from the launch pad at the Kennedy Space Center on January 28, 1986. After that disaster, the Shuttle program was suspended. Two years later, the shuttle flights were resumed, the agency had been revamped and was committed to avoiding a similar accident. Almost seventeen years later, the National Aeronautical and Space Administration (NASA) was taking even further precautions and carried out the launch on January 16, 2003 under extreme security measures. Columbia carried the first Israeli space voyager, Ilan Ramon into orbit. The agency feared that because of Ramon's nationality, the shuttle might have been a potential target of a terrorist act by groups opposed to the United States and Israel.Preliminary analysis seems to indicate that the shuttle and its crew fell victim to mechanical failure. Much like how the Columbia mission had received a lot of media coverage prior to launch, the Challenger mission was also the focus of America's attention. The crew of that mission included Christa McAuliffe. She was to become the first teacher to go into orbit. Aside from their pioneering nature, the final missions of the Challenger and Columbia shuttles bore other similarities. Perhaps the most striking similarity being the composition of their crews. Both missions had a crew of seven astronauts, both had two women and both had one African American Physisist. Another similarity was the foreboding of possible danger in both cases. The Challenger mission had been postponed due to unfavourable weather conditions, and despite apprehension by some engineers, the go ahead was given for launch. Cold weather was later determined to be one of the factors that impacted the Challenger catastrophe. In the case of Columbia, the cause or causes of the disaster are as yet undetermined, however just after lift off, a piece of insulating foam detached from the external fuel tank and struck the left wing of the orbiter. When asked about potential risk, the agency reassured the public that there was no cause for concern. In the aftermath of the disaster, NASA officials are insisting that even if the damage to the left wing of the shuttle turns out to have been the cause of the shuttle's break up, there is nothing that could have been done to save the seven member crew.
|
".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");
}
?>