Error: [$errno] $errstr on line $error_line in file $aFile -- $error_file -- $error_context -- referrer - $theAnekiReferrer" ); } $t="Canadian Provinces with the Highest IQ Scores"; $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="smartest_canadians"; $c=""; $map=""; $mapData=""; $mapCode=""; $seeRelated=""; //if(isset($_GET["t"])){$t=$_GET["t"];} //if(isset($_GET["table"])){$table=$_GET["table"];} //if(isset($_GET["places"])){$places=$_GET["places"];} //if(isset($_GET["decimals"])){$decimals=$_GET["decimals"];} //if(isset($_GET["unit"])){$unit=$_GET["unit"];} if(isset($_GET["orderby"])){$orderby=$_GET["orderby"];} if(isset($_GET["order"])){$order=$_GET["order"]; if($order==="asc"){$order_opposite="desc";}if($order==="desc"){$order_opposite="asc";}} if(isset($_GET["dependency"])){$dependency=$_GET["dependency"];} if(isset($_GET["number"])){$number=$_GET["number"];} if(isset($_GET["cntdn"])){$cntdn=$_GET["cntdn"];} if(isset($_GET["r"])){$r=$_GET["r"];} if(isset($_GET["measures"])){$measures=$_GET["measures"];} if(isset($_GET["units"])){$units=$_GET["units"];} //if(isset($_GET["file"])){$file=$_GET["file"];} if(isset($_GET["c"])){$c=$_GET["c"];} if(isset($_GET["map"])){$map=$_GET["map"];} if($table!="") { include("lr_324/wa2.php"); mysql_set_charset('utf8', $link); } if($number=="all") { $theNumber=""; } else { $theNumber=$number; } $theLocation=" in the World"; if($c=="europe") { $theLocation=" in Europe"; } if($c=="africa") { $theLocation=" in Africa"; } if($c=="asia") { $theLocation=" in Asia"; } if($c=="middle east") { $theLocation=" in the Middle East"; } if($c=="oceania") { $theLocation=" in Oceania"; } if($c=="caribbean") { $theLocation=" in the Caribbean"; } if($c=="south america") { $theLocation=" in South America"; } if($c=="central america") { $theLocation=" in Central America"; } if($c=="north america") { $theLocation=" in North America"; } $theTitle=str_replace("_"," ",$t); if($order=="desc") { if($theNumber==""){$theTitle="List of ".$theTitle;} else{ $containsTop = strrpos($theTitle,"Top"); if($containsTop===false){$theTitle="Top $theNumber ".$theTitle;} else{$theTitle="$theNumber ".$theTitle;} } $theDescription="List ranking the ".$theTitle." compiled by Aneki.com"; $theKeywords="top, countries, list, rank, order, world".str_replace("_",", ",$t).",".$dependency.".".$c; } else { $theTitle="List of ".str_replace("_"," ",$t); $theDescription="List ranking the ".str_replace("_"," ",$t)." compiled by Aneki.com"; $theKeywords="countries, list, rank, order, world, ".str_replace("_",", ",$t); } $arrayOfMeasures=explode("--",$measures); $units=str_replace("*","",$units); $arrayOfUnits=explode("--",$units); $decimals=str_replace("*","",$decimals); $arrayOfDecimals=explode("--",$decimals); $dependencyCondition=""; if($dependency=="none") { $dependencyCondition=" "; } else { $dependencyCondition=" AND (fb0.value=\"$dependency\")"; } $locationCondition=""; if($c=="europe") { $locationCondition=" AND (fb2.value LIKE \"%Europe,%\" OR fb2.name=\"Russia\" OR fb2.name=\"Turkey\") "; } if($c=="asia") { $locationCondition=" AND (fb2.value LIKE \"%Asia,%\" AND fb2.name!=\"Russia\" AND fb2.name!=\"Turkey\") "; } if($c=="africa") { $locationCondition=" AND (fb2.value LIKE \"%Africa,%\") "; } if($c=="oceania") { $locationCondition=" AND (fb2.value LIKE \"%Oceania,%\") "; } if($c=="south america") { $locationCondition=" AND (fb2.value LIKE \"%South America,%\") "; } if($c=="central america") { $locationCondition=" AND (fb2.value LIKE \"%Central America,%\") "; } if($c=="north america") { $locationCondition=" AND (fb2.value LIKE \"%North America,%\" OR fb2.name=\"Mexico\") "; } if($c=="middle east") { $locationCondition=" AND (fb2.value LIKE \"%Middle East,%\") "; } if($c=="caribbean") { $locationCondition=" AND (fb2.value LIKE \"%Caribbean,%\") "; } if($c=="americas") { $locationCondition=" AND (fb2.value LIKE \"%America,%\") "; } if($c=="asiapacific") { $locationCondition=" AND (fb2.value LIKE \"%Asia,%\" or fb2.value LIKE \"%Oceania,%\") "; } //if(strlen($orderby)<1) //{ //$orderby=$table.".value"; //$query_schema="SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = '$table' AND ORDINAL_POSITION =1"; //$result_schema=mysql_query($query_schema); //if($result_schema) //{ //while ($line = mysql_fetch_array($result_schema)) //{ //$orderby=$line[0]; //} //} //} if($map=="on") { $query_for_map = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.iso FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND ($table.value > 0)AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order"; //$query_for_map = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (($table.value > 0)AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order"; $result_for_map = mysql_query($query_for_map);// or mail("info@aneki.com", "countries2 error", "Sql error of ".$_SERVER["SCRIPT_NAME"].". Call to `$table` in ".__FILE__." ".$_GET["file"]." on line: ".__LINE__."
".mysql_error()."
SQL:
$query_for_map
"); if(!$result_for_map) { $query_for_map = "SELECT $table.country, $table.value, fb0.value, fbURLs.value, tblDataCodes.iso FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.country AND ($table.value > 0)AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order"; $result_for_map = mysql_query($query_for_map);// or mail("info@aneki.com", "countries2 error", "Sql error of ".$_SERVER["SCRIPT_NAME"].". Call to `$table` in ".__FILE__." ".$_GET["file"]." on line: ".__LINE__."
".mysql_error()."
SQL:
$query_for_map
"); } if($result_for_map && count($arrayOfMeasures)>1) { $num_rows = mysql_num_rows($result_for_map); $countryCount=0; while ($line = mysql_fetch_array($result_for_map)) { $theName=$line[4]; $theValue=$line[1]; if($theName=="Congo, Democratic Republic of the"){$theName="Congo, the Democratic Republic of the";} if($theName=="Cote d'Ivoire"){$theName="Côte d'Ivoire";} if(!strpos($theName,"'")) { $mapData=$mapData."data.setValue($countryCount, 0, '$theName');"; $mapData=$mapData."data.setValue($countryCount, 1, $theValue);"; } else { $mapData=$mapData."data.setValue($countryCount, 0, '".str_replace("'",""",$theName)."');"; $mapData=$mapData."data.setValue($countryCount, 1, $theValue);"; } $countryCount=$countryCount+1; } //} //$mapColors="0xD0E3F8, 0x0066ff, 0x0000ff"; $mapColors="0xD0E3F8, 0xbbbbbb, 0x0000ff"; if($order=="asc") { //$mapColors="0x0000ff, 0xD0E3F8, 0x0066ff"; $mapColors="0x0000ff, 0xD0E3F8, 0xbbbbbb"; } $mapCode="
"; } } ?> Canadian Provinces with the Highest IQ Scores isMobile()) { print" "; } else { print" "; } ?> isMobile()) { include("templates/template_top_mobile_3.html"); } else { include("templates/template_top.html"); } ?> isMobile()) { print"
"; } else { print"
"; } ?>
isMobile()) { print"
"; } else { print"
"; } ?>
isMobile()) { } else{ print"
"; include("templates/template_left.html"); print"
"; } if ($detect->isMobile()) { print"
"; } else { print"
"; } ?>
ProvinceEstimated IQ (avg.)
1Québec  110.065834
2British Columbia  109.363205
3Alberta  109.32365
4Ontario  109.12735
5Saskatchewan  108.49716
6Northwest Territories  108.19466
7Yukon  107.951675
8Manitoba  107.697266
9Nova Scotia  107.43514
10New Brunswick  106.88467
11Newfoundland and Labrador  105.35446
12Prince Edward Island  104.75792
13Nunavut  102.27193
Source: CBC
"; $sql_table_check = "SHOW TABLES LIKE '".$table."'"; $table_check_result = mysql_query($sql_table_check); if($table_check_result) { if( mysql_num_rows($table_check_result)) { //if($table!="") //{ //$indexArray = split("-",$r); //$theCondition="theIndex = 1000000"; //for($a=1;$a$line[1]"; //$relatedLink=str_replace('^^','',$relatedLink); //echo "
  • $relatedLink
  • "; //} //} //} //} $querydb="select tblDatabaseDriven.fileName, tblDatabaseDriven.condition, tblDatabaseDriven.related, tblDatabaseDriven.dataTable, tblDatabaseDriven.measure2, tblDatabaseDriven.columns, tblDatabaseDriven.display,tblDatabaseDriven.location FROM tblDatabaseDriven where tblDatabaseDriven.fileName=\"$file\""; $resultdb=mysql_query($querydb); $relatedKey=-1; if($resultdb) { $linedb=mysql_fetch_array($resultdb); //$file=$linedb[0]; $theCondition=$linedb[1]; $relatedKey=$linedb[2]; $dataTable=$linedb[3]; $measure2 = $linedb[4]; $tableColumns = $linedb[5]; $display=$linedb[6]; $location=$linedb[7]; } $seeRelated=""; if($relatedKey>0) { $queryRelated="select tblRelated.name, tblRelated.value FROM tblRelated where related=".$relatedKey; $resultRelated=mysql_query($queryRelated); $seeRelated=""; while(($lineRelated=mysql_fetch_array($resultRelated))) { $relatedFile=$lineRelated[0]; $relatedTitle=$lineRelated[1]; $seeRelated=$seeRelated."
  • ".$relatedTitle."
  • "."\n"; } } if($location=="europe") { $locationCondition=" AND (fb2.value LIKE \"%Europe,%\" OR fb2.name=\"Russia\" OR fb2.name=\"Turkey\") "; } if($location=="asia") { $locationCondition=" AND (fb2.value LIKE \"%Asia,%\" AND fb2.name!=\"Russia\" AND fb2.name!=\"Turkey\") "; } if($location=="africa") { $locationCondition=" AND (fb2.value LIKE \"%Africa,%\") "; } if($location=="oceania") { $locationCondition=" AND (fb2.value LIKE \"%Oceania,%\") "; } if($location=="south america") { $locationCondition=" AND (fb2.value LIKE \"%South America,%\") "; } if($location=="central america") { $locationCondition=" AND (fb2.value LIKE \"%Central America,%\") "; } if($location=="north america") { $locationCondition=" AND (fb2.value LIKE \"%North America,%\" OR fb2.name=\"Mexico\") "; } if($location=="middle east") { $locationCondition=" AND (fb2.value LIKE \"%Middle East,%\") "; } if($location=="caribbean") { $locationCondition=" AND (fb2.value LIKE \"%Caribbean,%\") "; } if($location=="americas") { $locationCondition=" AND (fb2.value LIKE \"%America,%\") "; } //include("lr_324/wa2.php"); //$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value tblDataCodes.fips FROM $table, fb0, fbURLs tblDataCodes WHERE (fb0.name=$table.name AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb0.value=\"independent\") order by $table.value $order)"; $query_b=mysql_query("SELECT * from $table LIMIT 1"); $columns = mysql_num_fields($query_b); for ($i = 0; $i < $columns; $i++) {$field_array[] = mysql_field_name($query_b, $i);} if($orderby==="value"){$orderby=$table.".value";} if(!(strpos($measures,"Country")===false) && in_array("name",$field_array) && in_array("value",$field_array)) //if(strpos($measures,"Country")===0 && in_array("name",$field_array) && in_array("value",$field_array)) //if(strpos($table,"fb")===0) { // This statement differs from the one below by the condition ($table.value > 0 OR CHAR_LENGTH($table.value)>0 ) //$query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND ($table.value > 0 OR CHAR_LENGTH($table.value)>0 )AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order"; $query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND ($table.value > 0)AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $orderby $order"; } else { $columnCheck=true; $theColumns=""; $arrayOfMeasures=split("--",$measures); foreach ($arrayOfMeasures as $aMeasure) { $theColumns=$theColumns.", ".$aMeasure; if(!in_array(strtolower($aMeasure), $field_array)){$columnCheck=False;} } $theColumns=substr($theColumns,1); echo""; if(strlen($tableColumns)>1) { $columnCheck=true; $theColumns=$tableColumns; } $orderPhrase=""; if(strlen($orderby)>1) { $orderPhrase="order by $orderby $order"; } if($columnCheck) { if(strlen($theCondition)>3) { $query1 = "SELECT $theColumns FROM $table where $theCondition $orderPhrase"; } else { $query1 = "SELECT $theColumns FROM $table $orderPhrase"; } } else { if(strlen($theCondition)>1) { $query1 = "SELECT * FROM $table where $theCondition $orderPhrase"; } else { $query1 = "SELECT * FROM $table $orderPhrase"; } } } if($table=="table_expensive_streets") { $query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips, $table.location FROM $table, fb0, fbURLs, tblDataCodes, fb2 WHERE (fb0.name=$table.name AND $table.value > 0 AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name". $dependencyCondition . $locationCondition .") order by $table.value $order"; } if($measures=="Population - Muslim and other faiths") { $query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips, fb70.value FROM $table, fb0, fbURLs, tblDataCodes, fb2, fb70 WHERE (fb0.name=$table.name AND $table.value > 0 AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name AND fb0.name=fb70.name AND (fb70.value LIKE \"Muslim%\" OR fb70.value LIKE \"Sunni%\") ". $dependencyCondition . $locationCondition .") order by $table.value $order"; } if($measures=="Population - Christian and other faiths") { $query1 = "SELECT $table.name, $table.value, fb0.value, fbURLs.value, tblDataCodes.fips, fb70.value FROM $table, fb0, fbURLs, tblDataCodes, fb2, fb70 WHERE (fb0.name=$table.name AND $table.value > 0 AND fb0.name = fbURLs.name AND fb0.name = tblDataCodes.name AND fb2.name=fb0.name AND fb0.name=fb70.name AND (fb70.value LIKE \"Christian%\" OR fb70.value LIKE \"Roman%\" OR fb70.value LIKE \"Protestant%\" OR fb70.name LIKE \"Nigeria\" ) ". $dependencyCondition . $locationCondition .") order by $table.value $order"; } define("sql_error_reporting",true); //result1 = mysql_query($query1) or mail("info@aneki.com", "countries2 error", "Sql error of ".$_SERVER["SCRIPT_NAME"].". Call to `$table` in ".__FILE__." ".$_GET["file"]." on line: ".__LINE__."
    ".mysql_error()."
    SQL:
    $query1
    "); $result1 = mysql_query($query1); echo""; if($result1) { $decimal='.'; $separator=','; $position=0; $num_rows=0; if($number=="all") { $num_rows = mysql_num_rows($result1); } else { $num_rows = $number; } if($table=="table_expensive_streets") { echo""; $theRows=""; while (($line = mysql_fetch_array($result1)) && ($position<$num_rows) ) { $position=$position+1; $modulus=($position%2)+1; $theNumber=number_format($line[1],$places,$decimal,$separator); //$countryLink=str_replace("http://www.aneki.com/","/",$line[5]); if($cntdn=="y") { $theRows="".$theRows; } else { $theRows=$theRows.""; } } echo"$theRows"; echo"
     CountryLocationRent (US $/sq.ft/yr)
    $position.$line[3]
    $line[5]$unit$theNumber
    $position$line[3]$unit$theNumber
    "; } else { //echo"
    "; //echo"
     
    "; //echo"
    view as: list / slideshow / map
    "; if(strrpos($display,"slide")===false) { echo"
    view as: list / map
    "; echo"
    view as: list / map
    "; if($map=="on") { print"$mapCode"; } echo""; $numberOfMeasures=0; foreach ($arrayOfMeasures as $aMeasure) { $aMeasure=urldecode($aMeasure); //echo""; if($numberOfMeasures==0) { echo""; } else { echo""; } $numberOfMeasures=$numberOfMeasures+1; } echo""; $theRows=""; $theTable=""; while (($line = mysql_fetch_array($result1)) && ($position<$num_rows) ) { $position=$position+1; $modulus=($position%2)+1; $theNumber=number_format($line[1],$places,$decimal,$separator); //$theRows=""; $theRows=""; //$theRows=""; for($kl=0;$kl<$numberOfMeasures;$kl++) { $theEntry=$line[$kl]; if(!(strrpos($arrayOfMeasures[$kl],"Height") === FALSE)){$feet=floor($theEntry/12);$inches=$theEntry%12;$theEntry=$feet."-".$inches;} if($arrayOfMeasures[$kl]==="Country" && !(strpos($query1,"fbURLs.value")===false)) //if($arrayOfMeasures[$kl]==="Country" && strpos($measures,"Country")===0) { $theCountryLink=$line[3]; $theCountryLink=str_replace("https://www.aneki.com/","/",$theCountryLink); if(!(strpos($theCountryLink,""; $theFlagImage=""; //$theFlagImage=""; //$theEntry="
    $aMeasure$aMeasure$aMeasure
    $position.
    $position.
    $position.
    $theFlagImage
    $theCountryLink
    "; //$theEntry="
    $theFlagImage$theCountryLink
    "; //$theEntry="
    $theFlagImage
    $theCountryLink
    "; //$theEntry="
    $theFlagImage$theCountryLink
    "; $theEntry="
    $theCountryLink
    "; } } if(isset($arrayOfDecimals[$kl]) && !($arrayOfMeasures[$kl]==="Year")) { if($arrayOfDecimals[$kl]==="" && is_numeric($theEntry)) { $theEntry=number_format($theEntry,0); } else if(!($arrayOfDecimals[$kl]==="") && is_numeric($theEntry)) { $theEntry=number_format($theEntry,$arrayOfDecimals[$kl]); } } if(isset($arrayOfUnits[$kl])) { if($kl===0) { //$theRows=$theRows."$arrayOfUnits[$kl]$theEntry "; $theUnit=rawurldecode($arrayOfUnits[$kl]); $theRows=$theRows."$theUnit$theEntry "; //$theRows=$theRows."$arrayOfUnits[$kl]$theEntry "; } if($kl>0) { $theUnit=rawurldecode($arrayOfUnits[$kl]); //$theRows=$theRows."$arrayOfUnits[$kl]$theEntry "; $theRows=$theRows."$theUnit$theEntry "; //$theRows=$theRows."$arrayOfUnits[$kl]$theEntry "; } } } if($cntdn=="y") { $theTable=$theRows.$theTable; } else { $theTable=$theTable.$theRows; } } $selected10=""; $selected25=""; $selected50=""; $selected100=""; $selectedAll=""; if($number==="10"){$selected10="SELECTED";} if($number==="25"){$selected25="SELECTED";} if($number==="50"){$selected50="SELECTED";} if($number==="100"){$selected100="SELECTED";} if($number==="all"){$selectedAll="SELECTED";} $selectForm="
    "; $theTable=$theTable."$selectForm"; if($number==5) { $thePrevious=""; if($file!="") { $thePrevious=" Previous  |  6 -10 | 1- 5 | "; } $theTable=$theTable."

    $thePrevious single page

    "; } if(!strrpos($display,"slide")) { echo"$theTable"; echo""; } } } } } } mysql_close($link); } ?>
    isMobile()) { //print" //
    //
    //"; //} //else //{ //print" //
    //"; //} ?> isMobile()) { include("templates/template_social_sharing_mobile.html"); } else { include("templates/template_social_sharing.html"); } ?> 10) { print"

    See Related

      "; echo"$seeRelated"; } ?> isMobile()) { print"
    "; } else { //begin detecting geo location function Dot2LongIP ($IPaddr) { if ($IPaddr == "") { return 0; } else { $ips = split ("\.", "$IPaddr"); return ($ips[3] + $ips[2] * 256 + $ips[1] * 65536 + $ips[0] *16777216); } } $ipnum= Dot2LongIp(getenv('REMOTE_ADDR') ); include("lr_324/wa3.php"); $query= "SELECT cn FROM geoip WHERE $ipnum >= start AND $ipnum <= end"; $result = mysql_query($query); $country=""; while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $country = $row['cn']; } //end detecting geo location echo"

    See Also

    "; echo""; mysql_close($link); print" "; } ?>


    isMobile()) { // any mobile platform } else { include("templates/template_right.html"); } ?>
    isMobile()) { include("templates/template_footer_mobile.html"); } else { include("templates/template_footer.html"); } ?>