Country Search - Database 'world'


Please enter only 3 alphabetic characters for the country code.

Please enter only alphabetic characters for the country name.

Click a letter to search for country code alphabetically:

Click an item below to display country information.

ABW - Aruba
AFG - Afghanistan
AGO - Angola
AIA - Anguilla
ALB - Albania
AND - Andorra
ANT - Netherlands Antilles
ARE - United Arab Emirates
ARG - Argentina
ARM - Armenia
ASM - American Samoa
ATA - Antarctica
ATF - French Southern territories
ATG - Antigua and Barbuda
AUS - Australia
AUT - Austria
AZE - Azerbaijan

AGO - Angola

Continent: Africa
Region: Central Africa
Surface Area: 1,246,700 sq. km
Year of Independence: 1975
Population: 12,878,000
Life Expectancy: 38.3 years
GNP: $6,648 million
Local Name: Angola
Form of Government: Republic
Head of State: José Eduardo dos Santos
Capital: Luanda

AO flag

Major Cities
Name District Population
Benguela Benguela 128,300
Huambo Huambo 163,100
Lobito Benguela 130,000
Luanda Luanda 2,022,000
Namibe Namibe 118,200
Languages
Language Status Percentage
Ambo - 2
Chokwe - 4
Kongo - 13
Luchazi - 2
Luimbe-nganguela - 5
Luvale - 4
Mbundu - 22
Nyaneka-nkhumbi - 5
Ovimbundu - 37

Programmer's Information

$country_code: AGO -
$search_char: A
TEST: $country_code: AGO
WHERE: WHERE LEFT(Code, 1) = 'A'
$country_code: AGO
$country_name:
$search_char: A

Country code query: "SELECT Code, Name FROM country WHERE LEFT(Code, 1) = 'A' ORDER BY Code ASC"
Country code query returned 17 rows
-----

$result->num_rows: 17
$country_code: AGO
$country_name:
$search_char: A

Country query: "SELECT Code, country.Name, Continent, Region, SurfaceArea, IndepYear, country.Population, LifeExpectancy, GNP, GNPOld, LocalName, GovernmentForm, HeadOfState, Capital, Code2, city.Name AS Capital_City FROM country, city WHERE Code = 'AGO' AND country.Capital = city.ID"
Country query returned 1 row

City query: "SELECT Name, CountryCode, District, Population FROM city WHERE CountryCode = 'AGO' ORDER BY Name ASC"
City query returned 5 rows

Language query: "SELECT Language, IsOfficial, Percentage FROM countrylanguage WHERE CountryCode = 'AGO' ORDER BY Language ASC"
Language query returned 9 rows

The PHP script that makes this page work was created and is copyright © 2008, 2021, 2024 by Dennis Langley, Palo Alto, California.