Error: [$errno] $errstr on line $error_line in file $aFile -- $error_file -- $error_context -- referrer - $theAnekiReferrer" ); } $t="The Most Beautiful Woman in the World - Miss World vs. Miss Universe"; $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="beautiful"; $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="
"; } } ?> The Most Beautiful Woman in the World - Miss World vs. Miss Universe 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"
"; } ?>

The Most Beautiful Woman in the World - Miss World vs. Miss Universe

COUNTRIES THAT HAVE WON THE MOST MISS WORLD TITLES
RankCountryNumber of Miss World Titles
1Venezuela5
1India5
3United Kingdom4
4Sweden3
4Jamaica3
4Netherlands3
7United States2
7South Africa2
7Iceland2
7Finland2
7Argentina2

COUNTRIES THAT HAVE WON THE MOST MISS UNIVERSE TITLES
RankCountryNumber of Miss Universe Titles
1United States7
2Venezuela4
2Puerto Rico4
4Sweden3
5Trinidad and Tobago2
5Thailand2
5Philippines2
5India2
5Finland2
5Brazil2

The Miss Universe organization is based in the United States while the Miss World competion is a United Kingdom based event.The United States owns the most Miss Universe titles and the United Kingdom has the third most Miss World titles. This may be mere coincidence. Nevertheless, for the sake of interest, here is a list of the countries with the most combined titles excluding the US and the UK.

COUNTRIES THAT HAVE WON THE MOST COMBINED MISS WORLD TITLES AND MISS UNIVERSE TITLES EXCLUDING MISS AMERICA AND MISS UNITED KINGDOM
RankCountryNumber of Combined Titles
1Venezuela9
2India7
3Sweden6
4Puerto Rico5
5Netherlands4
5Finland4
7Trinidad and Tobago3
7Brazil3
7South Africa3


"; $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"); } ?>