<?
$link =false;
set_error_handler("customError");
function customError($errno, $errstr, $error_file,$error_line,$error_context)
{
global $file;
$aFile=$_GET["file"];
$theAnekiReferrer=$_SERVER['HTTP_REFERER'];
//mail ("info@aneki.com", "countries2 Error","<b>Error:</b> [$errno] $errstr on line $error_line in file $aFile -- $error_file -- $error_context -- referrer - $theAnekiReferrer" );
}
$t="Most Populous Cities in Canada";
$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="most_populous_cities_canada";
$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 <b>".$_SERVER["SCRIPT_NAME"]."</b>. Call to `$table` in ".__FILE__."  ".$_GET["file"]." on line: ".__LINE__."<br>".mysql_error()."<br><b>SQL:</b><br>$query_for_map<br>");
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 <b>".$_SERVER["SCRIPT_NAME"]."</b>. Call to `$table` in ".__FILE__."  ".$_GET["file"]." on line: ".__LINE__."<br>".mysql_error()."<br><b>SQL:</b><br>$query_for_map<br>");
}

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("'","&quot;",$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="<tr><td colspan=4>
<div id='map_canvas'>
<script type='text/javascript' src='https://www.google.com/jsapi'></script>
<script type='text/javascript'>
google.load('visualization', '1', {'packages': ['geomap']});
google.setOnLoadCallback(drawMap);
var data;
var geomap;
function drawMap() {
data = new google.visualization.DataTable();
data.addRows($num_rows);
data.addColumn('string', 'Country');
data.addColumn('number', '$arrayOfMeasures[1]');
$mapData
var options = {};
options['dataMode'] = 'regions';
options['colors'] = [$mapColors];
options['width'] = '370px';
options['height'] = '185px';
options['showLegend'] = false;
var container = document.getElementById('map_canvas');
geomap = new google.visualization.GeoMap(container);
geomap.draw(data, options);
google.visualization.events.addListener(geomap, 'select', selectHandler);
}




function selectHandler(e) {
var selection=geomap.getSelection();
var item = selection[0];
var str = data.getValue(item.row,0);
var theURL = '/'+str+'.html';
document.location.href=theURL;
}

</script>
</div>
</td></tr>";
}
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" lang=en xmlns:fb="http://www.facebook.com/2008/fbml" xml:lang="en" lang="en" >
<head>
<TITLE>Most Populous Cities in Canada</TITLE>
<META name="description" content="Most Populous Cities in Canada">
<META name="keywords" content="most, populous, populated, population, cities, places, metropolitan, areas, america, canada, provinces, estimates">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="-1">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Distribution" content="Global" />
<meta name="Robots" content="index,follow" />

<meta property="og:title" content="Most Populous Cities in Canada"/>
<meta property="og:type" content="article"/>
<meta property="og:url" content="https://www.aneki.com/most_populous_cities_canada.html"/>
<meta property="og:image" content="https://www.aneki.com/images/top_world_rankings_list.png"/>
<meta property="og:site_name" content="Aneki.com"/>
<meta property="og:description" content="Most Populous Cities in Canada"/>
<meta property="fb:admins" content="100000078111398"/>

<link rel="canonical" href="https://www.aneki.com/most_populous_cities_canada.html" />

<!--
<link rel="alternate" type="application/rss+xml" title="World Rankings and Records" href="http://feeds2.feedburner.com/world_rankings" />
-->


<?
include("Mobile_Detect.php");
$detect = new Mobile_Detect();
//include("Mobile_Detect.php");
if ($detect->isMobile()) {
print"
<!-- Mobile Specific Metas
================================================== -->
<meta name=\"viewport\"  content=\"width=device-width, initial-scale=1, maximum-scale=1\">


<!-- CSS
================================================== -->
<link rel=\"stylesheet\"  href=\"stylesheets/base.css\">
<link rel=\"stylesheet\" href=\"stylesheets/skeleton.css\">
<link rel=\"stylesheet\" href=\"stylesheets/layout.css\">
<link rel=\"stylesheet\" media=\"all\" href=\"/stylesheets/style_m.css\">



<!--[if lt IE  9]>
<script src=\"http://html5shim.googlecode.com/svn/trunk/html5.js\"></script>
<![endif]-->

<!-- Favicons
================================================== -->
<link rel=\"shortcut icon\" href=\"images/favicon.ico\">
<link rel=\"apple-touch-icon\"  href=\"images/apple-touch-icon.png\">
<link rel=\"apple-touch-icon\" sizes=\"72x72\" href=\"images/apple-touch-icon-72x72.png\">
<link rel=\"apple-touch-icon\"  sizes=\"114x114\" href=\"images/apple-touch-icon-114x114.png\">

<!-- Scripts
================================================== -->

<script src=\"/javascripts/jq.js\"></script>

<script type=\"text/javascript\">

window.addEventListener(\"load\",function()
{
// Set a timeout...
setTimeout(function(){
// Hide the address bar!
window.scrollTo(0, 1);
}, 0);
});
$('.search-box,.menu' ).hide();
$('.options li:first-child').click(function(){
$(this).toggleClass('active');
$('.search-box').toggle();
$('.menu').hide();
$('.options li:last-child').removeClass('active');
});
$('.options li:last-child').click(function(){
$(this).toggleClass('active');
$('.menu').toggle();
$('.search-box').hide();
$('.options li:first-child').removeClass('active');
});
$('.content').click(function(){
$('.search-box,.menu' ).hide();
$('.options li:last-child, .options li:first-child').removeClass('active');
});

</script>

";


}
else
{
print"<link rel=\"stylesheet\" href=\"/stylesheets/style_v10210_aug1.css\" type=\"text/css\" />

<!-- Favicons
================================================== -->
<link rel=\"shortcut icon\" href=\"images/favicon.ico\">

";


}
?>


<script language="JavaScript">
function popUp(URL) {
day = new Date();
id = day.getTime();
eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=no,width=500,height=500');");
}
</script>

<script type="text/javascript" src="https://partner.googleadservices.com/gampad/google_service.js">
</script><script type="text/javascript">GS_googleAddAdSenseService("ca-pub-5472506631426118");GS_googleEnableAllServices();</script><script type="text/javascript">GA_googleAddSlot("ca-pub-5472506631426118", "Aneki_ROS_left_160x600");GA_googleAddSlot("ca-pub-5472506631426118", "Aneki_ROS_mid_300x250");</script><script type="text/javascript">GA_googleFetchAds();</script>


<script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script>

<script type='text/javascript'>
var googletag = googletag || {};
googletag.cmd = googletag.cmd || [];
(function() {
var gads = document.createElement('script');
gads.async = true;
gads.type = 'text/javascript';
var useSSL = 'https:' == document.location.protocol;
gads.src = (useSSL ? 'https:' : 'http:') +
'//www.googletagservices.com/tag/js/gpt.js';
var node = document.getElementsByTagName('script')[0];
node.parentNode.insertBefore(gads, node);
})();
</script>

<script type='text/javascript'>
googletag.cmd.push(function() {
googletag.defineSlot('/1041312/Aneki_ROS_left_160x600', [160, 600], 'div-gpt-ad-1355586756364-0').addService(googletag.pubads());
googletag.defineSlot('/1041312/Aneki_ROS_mid_300x250', [300, 250], 'div-gpt-ad-1355586756364-1').addService(googletag.pubads());
googletag.defineSlot('/1041312/Aneki_ROS_right_300x250', [300, 250], 'div-gpt-ad-1395634497006-0').addService(googletag.pubads());
googletag.defineSlot('/1041312/Aneki_ROS_right_300x250', [300, 250], 'div-gpt-ad-1407128141666-0').addService(googletag.pubads());
googletag.defineSlot('/1041312/Aneki_ROS_right_300x600', [300, 600], 'div-gpt-ad-1407093884234-0').addService(googletag.pubads());
googletag.defineSlot('/1041312/Aneki_ROS_top_728x90', [728, 90], 'div-gpt-ad-1355586756364-2').addService(googletag.pubads());
googletag.defineSlot('/1041312/Aneki_ROS_top_728x90', [728, 90], 'div-gpt-ad-1407093787840-0').addService(googletag.pubads());
googletag.defineSlot('/1041312/Aneki_ROS_bottom_728x90', [728, 90], 'div-gpt-ad-1407093627736-0').addService(googletag.pubads());
googletag.pubads().enableSingleRequest();
googletag.enableServices();
});
</script>

<script type="text/javascript">var switchTo5x=true;</script>
<script type="text/javascript" src="https://ws.sharethis.com/button/buttons.js"></script>
<script type="text/javascript">stLight.options({publisher: "14604b68-6f18-4f24-977e-3a19121ee4a2", doNotHash: true, doNotCopy: true, hashAddressBar: false});</script>
<!--
<script async="" defer="" src="//survey.g.doubleclick.net/async_survey?site=wcqbat4x32dic"></script>
-->
</head>

<body>

<?
if ($detect->isMobile()) {
include("templates/template_top_mobile_3.html");
}
else
{
include("templates/template_top.html");
}
?>

<?
if ($detect->isMobile()) {
print"<div style=\"margin-left:10px;\">";
}
else
{
print"<div id=\"maincontainer\">";
}
?>

<div>


<?
if ($detect->isMobile()) {
print"<div><div><div><div>";
}
else
{
print"
<div id=\"contentwrapper\">
<div id=\"contentcolumn\">
<div  class=\"contentcolunm-div\">
<div  class=\"contentcolunm-div\">
";
}
?>



<div>

<?

if ($detect->isMobile()) {
}
else{
print"<div id=\"main-content-left\">";
include("templates/template_left.html");
print"</div>";
}


if ($detect->isMobile()) {
print"<div>";
}
else
{
print"<div id=\"main-content-right\">";
}
?>

<div class="category-browse">
<a href="/most_populous_cities_canada.html">
<h1>
Most Populous Cities in Canada
</h1>
</a>
</div>




<table border=0 cellpadding=2 cellspacing=0 width="100%" bgcolor=eeeeee>
<tr bgcolor=#ffffff><td></td><td>City</td><td>Population (July 2006 estimate)</td></tr>
<tr bgcolor=#eeeeee><td>1</td><td>Toronto (Ont.)</td><td>&nbsp;&nbsp;5,304,100</td></tr>
<tr bgcolor=#ffffff><td>2</td><td>Montréal (Que.)</td><td>&nbsp;&nbsp;3,635,700</td></tr>
<tr bgcolor=#eeeeee><td>3</td><td>Vancouver (B.C.)</td><td>&nbsp;&nbsp;2,208,300</td></tr>
<tr bgcolor=#ffffff><td>4</td><td>Ottawa–Gatineau (Ont.–Que.)</td><td>&nbsp;&nbsp;1,148,800</td></tr>
<tr bgcolor=#eeeeee><td>5</td><td>Calgary (Alta.)</td><td>&nbsp;&nbsp;1,060,300</td></tr>
<tr bgcolor=#ffffff><td>6</td><td>Edmonton (Alta.)</td><td>&nbsp;&nbsp;1,016,000</td></tr>
<tr bgcolor=#eeeeee><td>7</td><td>Quebec (Que.)</td><td>&nbsp;&nbsp;717,600</td></tr>
<tr bgcolor=#ffffff><td>8</td><td>Hamilton (Ont.)</td><td>&nbsp;&nbsp;714,900</td></tr>
<tr bgcolor=#eeeeee><td>9</td><td>Winnipeg (Man.)</td><td>&nbsp;&nbsp;706,900</td></tr>
<tr bgcolor=#ffffff><td>10</td><td>London (Ont.)</td><td>&nbsp;&nbsp;464,300</td></tr>
<tr bgcolor=#eeeeee><td>11</td><td>Kitchener (Ont.)</td><td>&nbsp;&nbsp;458,600</td></tr>
<tr bgcolor=#ffffff><td>12</td><td>St. Catharines–Niagara (Ont.)</td><td>&nbsp;&nbsp;396,900</td></tr>
<tr bgcolor=#eeeeee><td>13</td><td>Halifax (N.S.)</td><td>&nbsp;&nbsp;380,800</td></tr>
<tr bgcolor=#ffffff><td>14</td><td>Windsor (Ont.)</td><td>&nbsp;&nbsp;332,300</td></tr>
<tr bgcolor=#eeeeee><td>15</td><td>Victoria (B.C.)</td><td>&nbsp;&nbsp;334,700</td></tr>
<tr bgcolor=#ffffff><td>16</td><td>Oshawa (Ont.)</td><td>&nbsp;&nbsp;340,300</td></tr>
<tr bgcolor=#eeeeee><td>17</td><td>Saskatoon (Sask.)</td><td>&nbsp;&nbsp;235,800</td></tr>
<tr bgcolor=#ffffff><td>18</td><td>Regina (Sask.)</td><td>&nbsp;&nbsp;199,000</td></tr>
<tr bgcolor=#eeeeee><td>19</td><td>St. John's (N.L.)</td><td>&nbsp;&nbsp;182,500</td></tr>
<tr bgcolor=#ffffff><td>20</td><td>Sherbrooke (Que.)</td><td>&nbsp;&nbsp;163,700</td></tr>
<tr bgcolor=#eeeeee><td>21</td><td>Greater Sudbury / Grand Sudbury (Ont.)</td><td>&nbsp;&nbsp;161,100</td></tr>
<tr bgcolor=#ffffff><td>22</td><td>Abbotsford (B.C.)1</td><td>&nbsp;&nbsp;162,800</td></tr>
<tr bgcolor=#eeeeee><td>23</td><td>Kingston (Ont.)1</td><td>&nbsp;&nbsp;156,200</td></tr>
<tr bgcolor=#ffffff><td>24</td><td>Saguenay (Que.)</td><td>&nbsp;&nbsp;153,000</td></tr>
<tr bgcolor=#eeeeee><td>25</td><td>Trois-Rivières (Que.)</td><td>&nbsp;&nbsp;142,200</td></tr>
<tr bgcolor=#ffffff><td>26</td><td>Saint John (N.B.)</td><td>&nbsp;&nbsp;126,700</td></tr>
<tr bgcolor=#eeeeee><td>27</td><td>Thunder Bay (Ont.)</td><td>&nbsp;&nbsp;126,500</td></tr>
<tr bgcolor=#eeeeee><td colspan=3 height = 2 align=right></td></tr>
<tr bgcolor=#ffffff><td colspan=3 align=right><font size=-2>Source: <i>Statistics Canada</i></font></td></tr>
</table>





<?
//if($table!="")
if($link)
{
echo"<!-- test  June 25 0-->";
$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<count($indexArray);$a++)
//{
//$theCondition= $theCondition." OR theIndex = ".$indexArray[$a];
//}
//$query2="SELECT name, value FROM tblRelated WHERE $theCondition";
//$result2 = mysql_query($query2);
//if($result2)
//{
//while (($line = mysql_fetch_array($result2))  )
//{
//if(strpos($line[1],"<")===false)
//{
//$relatedLink="<a class=\"list-links\" href=\"/$line[0].html\">$line[1]</a>";
//$relatedLink=str_replace('^^','',$relatedLink);
//echo "<li>$relatedLink</li>";
//}
//}
//}
//}
$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."<li> <a class=\"list-links\" href=\"/".$relatedFile.".html\">".$relatedTitle."</a></li>"."\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"<!--tableColumns: $tableColumns-->";
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 <b>".$_SERVER["SCRIPT_NAME"]."</b>. Call to `$table` in ".__FILE__."  ".$_GET["file"]." on line: ".__LINE__."<br>".mysql_error()."<br><b>SQL:</b><br>$query1<br>");


$result1 = mysql_query($query1);
echo"<!-- query1: $query1-->";
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"<table border=0 cellspacing=0 cellpadding=5 width=100%><tr class=list-title2><td class=rank-col1>&nbsp;</td><td class=rank-col2 width=50%>Country</td><td class=rank-col3>Location</td><td class=rank-col3>Rent (US $/sq.ft/yr)</td></tr>";

$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="<tr class=rank-row$modulus><td valign=middle class=rank-col1b>$position.</td><td valign=top class=rank-col2>$line[3]<br/><img src=\"https://www.aneki.com/flags/48/".strtolower(trim($line[4]))."-flag.png\" border=\"0\" width=\"48\"  height=\"48\"></td><td class=rank-col3>$line[5]</td><td class=rank-col3>$unit$theNumber</td></tr>".$theRows;
}
else
{
$theRows=$theRows."<tr class=rank-row$modulus><td class=rank-col1>$position</td><td class=rank-col2>$line[3]</td><td class=rank-col3>$unit$theNumber</td></tr>";
}



}
echo"$theRows";
echo"</table>";
}
else
{


//echo"<div class=\"dbTable\" style=\"text-align:center\"><table border=0 cellspacing=0 cellpadding=2 width=100%><tr class=dbTableRow1><td class=dbTableRow1>&nbsp;</td>";
//echo"<table border=0 cellspacing=0 cellpadding=0 width=100%><tbody><tr style=\"border-bottom:1px solid #eee\"><td style=\"border-bottom:1px solid #eee;font-weight:bold;padding-bottom:10px\" colspan=2>view as: list /<a href=\"/list_countries.php?t=$t&slide=1\" style=\"text-decoration:underline;color:#003399;\" > slideshow</a> /<a style=\"text-decoration:underline;color:#003399\" href=\"/$file.html?t=".urlencode($t)."&table=$table&places=$places=*&order=$order&orderby=$orderby&decimals=$decimals&dependency=$dependency&number=$number&cntdn=asc&r=$r&c=$c&measures=$measures&units=$units&file=$file&map=on\"> map</a></td><td style=\"border-bottom:1px solid #eee;font-weight:bold;\" align=middle></td></tr>";
//echo"<table border=0 cellspacing=0 cellpadding=0 width=100%><tbody><tr style=\"\"><td style=\"font-weight:bold;padding-bottom:10px\" colspan=2>view as: list /<a style=\"text-decoration:underline;color:#003399\" href=\"/$file.html?t=".urlencode($t)."&table=$table&places=$places=*&order=$order&orderby=$orderby&decimals=$decimals&dependency=$dependency&number=$number&cntdn=asc&r=$r&c=$c&measures=$measures&units=$units&file=$file&map=on\"> map</a></td><td style=\"font-weight:bold;\" align=middle></td></tr>";

if(strrpos($display,"slide")===false)
{

echo"<div  style=\"font-weight:bold;padding-bottom:10px\">view as: list /<a style=\"text-decoration:underline;color:#003399\" href=\"/$file.html?t=".urlencode($t)."&table=$table&places=$places=*&order=$order&orderby=$orderby&decimals=$decimals&dependency=$dependency&number=$number&cntdn=asc&r=$r&c=$c&measures=$measures&units=$units&file=$file&map=on\"> map</a></div>";
echo"<table border=0 cellspacing=0 cellpadding=0 width=100%><tbody>";

if($map=="on")
{
print"$mapCode";
}

echo"<tr style=\"border-bottom:1px solid #eee\"><td style=\"border-bottom:1px solid #eee;font-weight:bold\"><a href=\"/$file.html?order=$order&orderby=$orderby&number=$number\" style=\"color:#003399\">&#9650;</a></td>";
$numberOfMeasures=0;
foreach ($arrayOfMeasures as $aMeasure) {
$aMeasure=urldecode($aMeasure);
//echo"<td class=dbTableRow1>$aMeasure</td>";

if($numberOfMeasures==0)
{

echo"<td style=\"border-bottom:1px solid #eee;font-weight:bold\"><a style=\"text-decoration:underline;color:#003399\" href=\"/$file.html?order=$order_opposite&orderby=$table.".mysql_field_name($result1, $numberOfMeasures)."&number=$number\">$aMeasure</a></td>";
}
else
{
echo"<td align=\"center\" style=\"border-bottom:1px solid #eee;font-weight:bold\"><a style=\"text-decoration:underline;color:#003399\" href=\"/$file.html?order=$order_opposite&orderby=$table.".mysql_field_name($result1, $numberOfMeasures)."&number=$number\">$aMeasure</a></td>";
}
$numberOfMeasures=$numberOfMeasures+1;


}
echo"</tr>";
$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="<tr class=rank-row$modulus width=\"100%\"><td valign=middle class=rank-col1b>$position.</td>";
$theRows="<tr style=\"border-bottom:1px solid #eee\"><td style=\"border-bottom:1px solid #eee\">$position.</td>";
//$theRows="<tr class=rank-row$modulus width=\"100%\"><td valign=middle class=rank-col1b>$position.</td>";

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,"<a")=== false))
{
//$theCountryLink = str_replace("<a ","<a style=\"text-decoration:underline;\" ",$theCountryLink);
$theCountryLink = str_replace("<a ","<a class=\"list-links\" ",$theCountryLink);

$hrefStart=strpos($theCountryLink,"href")+6;
$hrefEnd=strpos($theCountryLink,"\"",$hrefStart+6);
$theCountryURL=substr($theCountryLink,$hrefStart,$hrefEnd-$hrefStart);
//$theFlagImage="<a href=\"$theCountryURL\"><img src=\"http://www.masquot.com/flags/48/".strtolower(trim($line[4]))."-flag.png\" border=\"0\"  width=\"48\" height=\"48\" /></a>";
$theFlagImage="<a href=\"$theCountryURL\"><img src=\"https://www.aneki.com/flags/48/".strtolower(trim($line[4]))."-flag.png\" border=\"0\"  width=\"16\" height=\"16\" style=\"margin:0;padding:0;position:relative;top:2px;padding-right:3px;\" /></a>";
//$theFlagImage="<a href=\"$theCountryURL\"><img src=\"http://www.masquot.com/flags/48/".strtolower(trim($line[4]))."-flag.png\" border=\"0\"  width=\"48\" height=\"48\" /></a>";

//$theEntry="<table border=0 cellspacing=0 cellpadding=0 height=100%><tr><td>$theFlagImage</td><td valign=middle width=150px><br/>$theCountryLink</td></tr></table>";
//$theEntry="<table border=0 cellspacing=0 cellpadding=0><tr><td>$theFlagImage</td><td>$theCountryLink</td></tr></table>";
//$theEntry="<table border=0 cellspacing=0 cellpadding=0 height=100%><tr><td>$theFlagImage</td><td valign=middle width=50px><br/>$theCountryLink</td></tr></table>";
//$theEntry="<table border=0 cellspacing=0 cellpadding=0><tr><td>$theFlagImage</td><td>$theCountryLink</td></tr></table>";
$theEntry="<table border=0 cellspacing=0 cellpadding=0><tr><td></td><td>$theCountryLink</td></tr></table>";

}
}

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."<td valign=middle class=rank-col4b>$arrayOfUnits[$kl]$theEntry </td>";
$theUnit=rawurldecode($arrayOfUnits[$kl]);
$theRows=$theRows."<td style=\"border-bottom:1px solid #eee;padding-top:5px;padding-bottom:5px;\" >$theUnit$theEntry </td>";
//$theRows=$theRows."<td valign=middle class=rank-col4b>$arrayOfUnits[$kl]$theEntry </td>";

}
if($kl>0)
{
$theUnit=rawurldecode($arrayOfUnits[$kl]);
//$theRows=$theRows."<td valign=middle class=rank-col4b style=\"text-align:center\">$arrayOfUnits[$kl]$theEntry </td>";
$theRows=$theRows."<td align=\"center\" style=\"border-bottom:1px solid #eee;padding-top:5px;padding-bottom:5px;\" >$theUnit$theEntry </td>";
//$theRows=$theRows."<td valign=middle class=rank-col4b style=\"text-align:center\">$arrayOfUnits[$kl]$theEntry </td>";

}

}
}


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="
<form style=\"margin-bottom:0px;margin-top:5px\"name =\"theForm\"  id =\"theForm\" action= \"/$file.html\" method=\"GET\">
<table cellspacing=0 cellpadding=0 border=0>
<tr><td>
<label>Rows:&nbsp;</label>
</td>
<td>
<select name=\"number\"  id=\"number\" onchange=\"if(document.getElementById('number')!=null){document.getElementById('theForm').submit();}\"  style=\"width:60px;\">
<option value='10' $selected10>10
<option value='25' $selected25>25
<option value='50' $selected50>50
<option value='100'$selected100>100
<option value='all'>Full List</select>
</td>
</tr></table></form>
";

$theTable=$theTable."<tr style=\"border-bottom:1px solid #eee\"><td style=\"\"><span><a href=\"/$file.html?&order=$order&orderby=$orderby&number=$number&cntdn=asc\"  style=\"color:#003399\">&#9660;</a></span></td><td></td><td align=\"middle\" valign=\"bottom\">$selectForm</td></tr>";

if($number==5)
{
$thePrevious="";
if($file!="")
{
$thePrevious="<a class=\"list-links-navigate\"href=\"/$file.html\"> Previous</a> &nbsp;|&nbsp;
<a class=\"list-links-navigate\"href=\"/$file.html\"> 6 -10</a>&nbsp;|&nbsp;1- 5 |&nbsp;";
}
$theTable=$theTable."
<tr>
<td class=\"list-links-navigate\" align=\"center\" colspan=\"4\">
<p>
$thePrevious
<a class=\"list-links-navigate\"href=\"/$file.html?t=".urlencode($t)."&table=$table&places=$places=*&order=$order&orderby=$orderby&decimals=$decimals&dependency=$dependency&number=all&cntdn=asc&r=$r&c=$c&measures=$measures&units=$units&file=$file\">single page</a>
</p>
</td>
</tr>
";
}

if(!strrpos($display,"slide"))
{
echo"$theTable";

echo"</table>";
}


}



}
}
}
}
mysql_close($link);
}
?>




<br/>
<!--
<div style='float:left; margin:top:3px;'>


<br/>

<div style='float:left; margin:top:3px;'>

<span id="">
<a class="list-links" style="font-weight:bold;text-decoration:underline" href="javascript:popUp('/spreadtheword.php?thereferer=/most_populous_cities_canada.html&linktitle=Most Populous Cities in Canada - Aneki.com')" title="E-mail this to a friend">E-mail this</a>
</span>
</div>
<div style='float:left;margin-left:10px;width:100px;'>

<a href="https://twitter.com/share" class="twitter-share-button" data-url="/most_populous_cities_canada.html" data-count="horizontal" data-text="Most Populous Cities in Canada" data-via="world_rankings" ></a><script type="text/javascript" src="https://platform.twitter.com/widgets.js"></script>
</div>


<div style='float:left; margin-left:0px;width:65px;'>

<script type='text/javascript' src='https://apis.google.com/js/plusone.js'></script><g:plusone size='medium' href='/most_populous_cities_canada.html'></g:plusone>
</div>
-->
<?
//if ($detect->isMobile()) {
//print"
//<br/>
//<div id=\"fb-root\" style=\"margin-top:3px;\"></div>
//";
//}
//else
//{
//print"
//<div id=\"fb-root\" style=\"float:left;margin-left:2px;\"></div>
//";
//}
?>


<!--
<script src="http://connect.facebook.net/en_US/all.js#xfbml=1"></script>
<fb:like href="/most_populous_cities_canada.html" show_faces="false" action="recommend" layout="button_count" width="90" send="true">
</fb:like>
<br/>

-->


<?
if ($detect->isMobile()) {
include("templates/template_social_sharing_mobile.html");
}
else
{
include("templates/template_social_sharing.html");
}
?>

<!--<div class="category-browse"> -->
<!--<div class="category-browse-title">-->
<!--See Also-->
<!--</div>-->



<?
if(strlen($seeRelated)>10)
{
print"

<div class=\"category-browse\">
<h3 style=\"color:#333;size:18px\">
See Related
</h3>
<ul class=\"list4\">
";
echo"$seeRelated";

}
?>

<?
if ($detect->isMobile()) {
print"
</ul>
";
}
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"<h3 style=\"color:#333;size:18px\">See Also</h3>";
echo"<ul class=\"list4\">";
if($country == "United States")
{
echo"
<li> <a class=\"list-links\" href=\"/america_unemployment_rate_states.html\">US States with the Highest Unemployment Rates</a></li>
<li> <a class=\"list-links\" href=\"/america_gas_prices_states.html\">American States with the Highest Gas Prices</a></li>
<li> <a class=\"list-links\" href=\"/america_gas_prices_cities.html\">American Cities with the Highest Gas Prices</a></li>
<li> <a class=\"list-links\" href=\"/america_home_prices_cities.html\">Cities with the Highest Home Prices in America</a></li>
<li> <a class=\"list-links\" href=\"/america_median_home_income_states.html\">US States with the Highest Median Home Income</a></li>
<li> <a class=\"list-links\" href=\"/america_identity_theft_victims_states.html\">US States with the Most Identity Theft Victims</a></li>
<li> <a class=\"list-links\" href=\"/america_hate_crimes_reported_state.html\">US States with the Highest Rate of Reported Hate Crimes</a></li>
";
}
if($country == "Canada"){
echo "
<li> <a class=\"list-links\" href=\"/canada_homicide_rate_province.html\">Canadian Provinces with the Highest Homicide Rates</a></li>
<li> <a class=\"list-links\" href=\"/canada_languages.html\">Most Commonly Spoken Languages in Canada</a></li>
<li> <a class=\"list-links\" href=\"/canada_most_visited_countries.html\">Most Visited Countries by Canadians</a></li>
<li> <a class=\"list-links\" href=\"/canada_smoking_prevalence_province.html\">Canadian Provinces with the Highest Smoking Prevalence</a></li>
<li> <a class=\"list-links\" href=\"/canada_male_life_expectancy_provinces.html\">Canadian Provinces with the Highest Male Life Expectancies</a></li>
<li> <a class=\"list-links\" href=\"/canada_female_life_expectancy_provinces.html\">Canadian Provinces with the Highest Female Life Expectancies</a></li>
<li> <a class=\"list-links\" href=\"/canada_cost_of_living_province.html\">Canadian Cities with the Highest Cost of Living</a></li>
<li> <a class=\"list-links\" href=\"/canada_heavy_drinkers_province.html\">Canadian Provinces with the Heaviest Drinkers</a></li>
<li> <a class=\"list-links\" href=\"/canada_obesity_rates_province.html\">Canadian Provinces with the Highest Obesity Rates</a></li>
<li> <a class=\"list-links\" href=\"/canada_exports.html\">Canada's Biggest Exports</a></li>
<li> <a class=\"list-links\" href=\"/canada_gas_prices_provinces.html\">Canadian Provinces with the Highest Gas Prices</a></li>
<li> <a class=\"list-links\" href=\"/canada_gas_prices_cities.html\">Canadian Cities with the Highest Gas Prices</a></li>
";
}
echo"</ul>";
mysql_close($link);


print"
<ul class=\"list4\">
<li><a class=\"list-links\" href=\"/earthquake_prone_countries.html\">Earthquake Prone Countries</a></li>
<li><a class=\"list-links\" href=\"/english.html\">English Speaking Countries</a></li>
<li><a class=\"list-links\" href=\"/happiest_countries.html\">Happiest Countries</a></li>
<li><a class=\"list-links\" href=\"/most_educated.html\">Most Educated Countries</a></li>
<li><a class=\"list-links\" href=\"/hottest.html\">Hottest Places in the World</a></li>
<li><a class=\"list-links\" href=\"/socialist.html\">Socialist Countries</a></li>
<li><a class=\"list-links\" href=\"/populated.html\">Population</a></li>
<li><a class=\"list-links\" href=\"/dangerous.html\">Dangerous Countries to Live in</a></li>
<li><a class=\"list-links\" href=\"/oil_countries.html\">Oil Producing Countries</a></li>
<li><a class=\"list-links\" href=\"/largest.html\">Largest geographical Area</a></li>
<li><a class=\"list-links\" href=\"/expensive.html\">Cost of Living</a></li>
<li><a class=\"list-links\" href=\"/oil.html\">Countries with the largest Oil Reserves</a></li>
<li><a class=\"list-links\" href=\"/least_happy_countries.html\">Least Happy Countries</a></li>
<li><a class=\"list-links\" href=\"/corruption_leaders.html\">Most Corrupt World Leaders</a></li>
<li><a class=\"list-links\" href=\"/best_gender_equality.html\">Best Countries for Gender Equality</a></li>
<li><a class=\"list-links\" href=\"/asylum_seekers.html\">Industrialized Countries receiving the most Asylum Seekers</a></li>
<li><a class=\"list-links\" href=\"/Developed_Countries.html\">Developed Countries</a></li>
<li><a class=\"list-links\" href=\"/watch_tv.html\">Countries with the Biggest TV Watchers</a></li>
<li><a class=\"list-links\" href=\"/avalanche_prone_countries.html\">Avalanche Prone Countries</a></li>
<li><a class=\"list-links\" href=\"/Developing_Countries.html\">Developing Countries</a></li>
<li><a class=\"list-links\" href=\"/space.html\">First Countries to send a Man to Space</a></li>
<li><a class=\"list-links\" href=\"/cheapest_travel.html\">Cheapest Countries to Travel to</a></li>
<li><a class=\"list-links\" href=\"/tsunami_prone_countries.html\">Tsunami Prone Countries</a></li>
<li><a class=\"list-links\" href=\"/communist.html\">Communist Countries</a></li>
<li><a class=\"list-links\" href=\"/best_airports.html\">World's Best Airports</a></li>
<li><a class=\"list-links\" href=\"/coldest.html\">Coldest Places in the World</a></li>
<li><a class=\"list-links\" href=\"/busiest_airports.html\">Busiest Airports in the World</a></li>
<li><a class=\"list-links\" href=\"/g8.html\">Members of the G8</a></li>
<li><a class=\"list-links\" href=\"/cup.html\">Countries to have won the Most World Cups</a></li>
<li><a class=\"list-links\" href=\"/nuclear.html\">Countries with Nuclear Weapons</a></li>
<li><a class=\"list-links\" href=\"/best_cities.html\">Best Cities</a></li>
<li><a class=\"list-links\" href=\"/spanish.html\">Spanish Speaking Countries</a></li>
<li><a class=\"list-links\" href=\"/safest_children.html\">Safest Countries for Children</a></li>
<li><a class=\"list-links\" href=\"/beautiful.html\">Countries with the Most Miss Universe Winners</a></li>
<li><a class=\"list-links\" href=\"/mountains.html\">Highest Mountains in the World</a></li>
<li><a class=\"list-links\" href=\"/hiv.html\">HIV prevalence</a></li>
<li><a class=\"list-links\" href=\"/health.html\">Countries with the best health care</a></li>
<li><a class=\"list-links\" href=\"/children.html\">Best Countries for Children</a></li>
<li><a class=\"list-links\" href=\"/women_leaders.html\">Countries with Women Leaders</a></li>
<li><a class=\"list-links\" href=\"/women_parliament.html\">Countries with the Highest Percentage of Women in Parliament</a></li>
<li><a class=\"list-links\" href=\"/melanoma_cancer_countries.html\">Countries with the Highest Incidence of Skin Melanoma</a></li>
<li><a class=\"list-links\" href=\"/countries_olympic_gold.html\">Countries with the Most Olympic Gold Medals</a></li>
<li><a class=\"list-links\" href=\"/debt.html\">Highest National Debt</a></li>
<li><a class=\"list-links\" href=\"/highest_employment.html\">Countries with the Highest Employment Rates</a></li>
<li><a class=\"list-links\" href=\"/languages.html\">Commonly Spoken Languages</a></li>
<li><a class=\"list-links\" href=\"/immigrant_population.html\">Countries with the Largest Immigrant Populations</a></li>
<li><a class=\"list-links\" href=\"/tourist_destinations.html\">Fastest Growing Tourist Destinations</a></li>
<li><a class=\"list-links\" href=\"/platinum_countries.html\">Platinum Producing Countries</a></li>
<li><a class=\"list-links\" href=\"/hurricane_prone_countries.html\">Hurricane Prone Countries</a></li>
<li><a class=\"list-links\" href=\"/breast_cancer_countries.html\">Countries with the Highest Incidence of Breast Cancer</a></li>
<li><a class=\"list-links\" href=\"/longest_serving_leaders.html\">Longest Serving World Leaders</a></li>
<li><a class=\"list-links\" href=\"/arabic.html\">Arabic Speaking Countries</a></li>
<li><a class=\"list-links\" href=\"/drought_prone_countries.html\">Drought Prone Countries</a></li>
<li><a class=\"list-links\" href=\"/roman_catholic_countries.html\">Roman Catholic Countries</a></li>
<li><a class=\"list-links\" href=\"/smartest_cities.html\">Smartest Cities in America</a></li>
<li><a class=\"list-links\" href=\"/portuguese.html\">Portuguese Speaking Countries</a></li>
<li><a class=\"list-links\" href=\"/rivers.html\">Longest Rivers in the World</a></li>
<li><a class=\"list-links\" href=\"/foreign_population.html\">Countries with the Largest Foreign Populations</a></li>
<li><a class=\"list-links\" href=\"/monarchies.html\">Countries that have Monarchies</a></li>
<li><a class=\"list-links\" href=\"/largest_islands.html\">Largest Islands in the World</a></li>
<li><a class=\"list-links\" href=\"/illiteracy.html\">Highest Illiteracy Rates</a></li>
<li><a class=\"list-links\" href=\"/dangerous_cities.html\">Dangerous Cities</a></li>
<li><a class=\"list-links\" href=\"/italian.html\">Italian Speaking Countries</a></li>
<li><a class=\"list-links\" href=\"/visited.html\">Most Visited Countries</a></li>
<li><a class=\"list-links\" href=\"/cleanest_cities.html\">Cleanest Cities</a></li>
<li><a class=\"list-links\" href=\"/unemployment.html\">Unemployment</a></li>
<li><a class=\"list-links\" href=\"/military.html\">Military Expenditure</a></li>
<li><a class=\"list-links\" href=\"/universities.html\">Most Universities</a></li>
<li><a class=\"list-links\" href=\"/phones.html\">Mobile phone users</a></li>
<li><a class=\"list-links\" href=\"/overweight.html\">Countries with the Largest overweight Populations</a></li>
<li><a class=\"list-links\" href=\"/biggest_drinkers.html\">Countries with the Biggest Drinkers</a></li>
<li><a class=\"list-links\" href=\"/worst_cities.html\">Worst Cities</a></li>
<li><a class=\"list-links\" href=\"/gold_countries.html\">Gold Producing Countries</a></li>
<li><a class=\"list-links\" href=\"/birth.html\">Highest Birth Rates</a></li>
<li><a class=\"list-links\" href=\"/worst_gender_equality.html\">Worst Countries for Gender Equality</a></li>
<li><a class=\"list-links\" href=\"/french.html\">French Speaking Countries</a></li>
<li><a class=\"list-links\" href=\"/highest_paying_jobs.html\">Highest Paying Jobs</a></li>
<li><a class=\"list-links\" href=\"/expensive_cities.html\">Expensive Cities</a></li>
<li><a class=\"list-links\" href=\"/most_populous_states_america.html\">Most Populous States in America</a></li>
<li><a class=\"list-links\" href=\"/polite_cities_world.html\">Most Polite Cities in the World</a></li>
<li><a class=\"list-links\" href=\"/cleanest.html\">Cleanest</a></li>
<li><a class=\"list-links\" href=\"/quality.html\">Countries with the Highest Quality of Life</a></li>
<li><a class=\"list-links\" href=\"/lowest_accident_deaths.html\">Countries with the Lowest Rate of Deaths from Road Accidents</a></li>
<li><a class=\"list-links\" href=\"/most_dangerous_cities_america.html\">Most Dangerous Cities in America</a></li>
<li><a class=\"list-links\" href=\"/independence.html\">Newest countries</a></li>
<li><a class=\"list-links\" href=\"/European_Union.html\">European Union Countries</a></li>
<li><a class=\"list-links\" href=\"/teenage_pregnancy.html\">Highest Teenage Pregnancy Rates in Developed Countries</a></li>
<li><a class=\"list-links\" href=\"/best_cities_singles_america.html\">Best Cities for Singles in America</a></li>
<li><a class=\"list-links\" href=\"/most_depressing_job.html\">Most Depressing Jobs</a></li>
<li><a class=\"list-links\" href=\"/most_populous_cities_canada.html\">Most Populous Cities in Canada</a></li>
<li><a class=\"list-links\" href=\"/most_generous_countries.html\">Most Generous Countries</a></li>
<li><a class=\"list-links\" href=\"/poorest.html\">Poorest Countries in the World</a></li>
<li><a class=\"list-links\" href=\"/richest.html\">Richest Countries in the World</a></li>
<li><a class=\"list-links\" href=\"/driest.html\">Driest Places in the World</a></li>
<li><a class=\"list-links\" href=\"/greatest_athletes_active.html\">World's Greatest Athletes</a></li>
<li><a class=\"list-links\" href=\"/affordable_cities.html\">Most Affordable US Cities</a></li>
<li><a class=\"list-links\" href=\"/suicide.html\">Countries with the Highest Suicide rates</a></li>
<li><a class=\"list-links\" href=\"/polluted_cities.html\">World's Most Polluted Cities</a></li>
<li><a class=\"list-links\" href=\"/safest_cities_america.html\">Safest Cities in America</a></li>
<li><a class=\"list-links\" href=\"/holidays.html\">National Holidays</a></li>
<li><a class=\"list-links\" href=\"/airports.html\">Most Airports</a></li>
<li><a class=\"list-links\" href=\"/most_googled.html\">Most Googled Countries</a></li>
<li><a class=\"list-links\" href=\"/obesity.html\">Countries with the Highest Obesity Rates</a></li>
<li><a class=\"list-links\" href=\"/popular_websites.html\">World's Most Popular Websites</a></li>
</ul>
";


}
?>
</div>
</div>
</div>
<br/>
<br/>
</div>
</div>
<div id="subclear">
</div>
</div>
</div>



<div id="rightcolumn">

<?
if ($detect->isMobile()) {
// any mobile platform
}
else
{
include("templates/template_right.html");
}
?>


</div>
</div>







<!-- BEGIN footer -->

<?
if ($detect->isMobile()) {
include("templates/template_footer_mobile.html");
}
else
{
include("templates/template_footer.html");
}
?>