$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". $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". $query_b=mysql_query("SELECT * from $table LIMIT 1") įor ($i = 0 $i 0 OR CHAR_LENGTH($table.value)>0 ) $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)" ![]() $locationCondition=" AND (fb2.value LIKE \"%America,%\") " $locationCondition=" AND (fb2.value LIKE \"?ribbean,%\") " $locationCondition=" AND (fb2.value LIKE \"%Middle East,%\") " $locationCondition=" AND (fb2.value LIKE \"%North America,%\" OR fb2.name=\"Mexico\") " $locationCondition=" AND (fb2.value LIKE \"?ntral America,%\") " $locationCondition=" AND (fb2.value LIKE \"%South America,%\") " $locationCondition=" AND (fb2.value LIKE \"%Oceania,%\") " $locationCondition=" AND (fb2.value LIKE \"?rica,%\") " $locationCondition=" AND (fb2.value LIKE \"%Asia,%\" AND fb2.name!=\"Russia\" AND fb2.name!=\"Turkey\") " $locationCondition=" AND (fb2.value LIKE \"%Europe,%\" OR fb2.name=\"Russia\" OR fb2.name=\"Turkey\") " While(($lineRelated=mysql_fetch_array($resultRelated))) ![]() km) Continent Population Prospects 2050 1: China (incl. $resultRelated=mysql_query($queryRelated) Country Population July 2018 Population density (per sq. $queryRelated="select tblRelated.name, tblRelated.value FROM tblRelated where related=".$relatedKey $querydb="select tblDatabaseDriven.fileName, ndition, tblDatabaseDriven.related, tblDatabaseDriven.dataTable, asure2, lumns, tblDatabaseDriven.display,tblDatabaseDriven.location FROM tblDatabaseDriven where tblDatabaseDriven.fileName=\"$file\"" $table_check_result = mysql_query($sql_table_check) The worlds least populous country, Holy See, is located in Europe. As of 2021, 15 countries have a population above 10 million. The top five countries together hold a 57 share of the Europe population. Russia is followed by Germany, United Kingdom, France, and Italy. Will India take over China to become the most populous country in the world?īy looking at the growth in India and the high fertility rate of 2.24, it is possible, just a matter of time.$sql_table_check = "SHOW TABLES LIKE '".$table."'" Russia is the only European country with a total number of humans above 100 mn. ![]() India, the country with the second-highest population in the world, is not far behind, raking 17.7% of the world’s share of population and has a fertility rate of 2.24, which is higher than China at 1.69. In other words, for every 5.4 people in the world, 1 is from China. Here’s the world population share by each region:Ĭhina, the most populous country, is taking a large piece of population share of 18.5% from the total world population of 7.74 billion. These 3 countries are notable with their high yearly increments in the country population.Įurope region is the worst performer in population growth, losing 6 countries in the top 20 rankings. The three new members on the list are Thailand, Iran, and the Philippines.Īfrica region is catching up with the 3 new members in the top 20 list, which are Ethiopia, Egypt, and DR Congo. In 2020, out of the top 20 countries with the most population, 11 are from Asia, 4 are from Africa, 2 are from Europe, 2 are from Latin America/Caribbean, and 1 is from Northern America.Ĭompared to 1955, Asia countries up by 3 from 8, Africa up by 3 from 1, Latin America/Caribbean and Northern America remain at 2 and 1 respectively, and Europe drop by 6 from 8.Īsia remains the region with the highest population, including the top 2 most populated countries – China and India, as well as the highest number of countries in the top 20 list.
0 Comments
Leave a Reply. |