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

AUS - Australia

Continent: Oceania
Region: Australia and New Zealand
Surface Area: 7,741,220 sq. km
Year of Independence: 1901
Population: 18,886,000
Life Expectancy: 79.8 years
GNP: $351,182 million
Local Name: Australia
Form of Government: Constitutional Monarchy, Federation
Head of State: Elisabeth II
Capital: Canberra

AU flag

Major Cities
Name District Population
Adelaide South Australia 978,100
Brisbane Queensland 1,291,117
Cairns Queensland 92,273
Canberra Capital Region 322,723
Central Coast New South Wales 227,657
Geelong Victoria 125,382
Gold Coast Queensland 311,932
Hobart Tasmania 126,118
Melbourne Victoria 2,865,329
Newcastle New South Wales 270,324
Perth West Australia 1,096,829
Sydney New South Wales 3,276,207
Townsville Queensland 109,914
Wollongong New South Wales 219,761
Languages
Language Status Percentage
Arabic - 1
Canton Chinese - 1
English Official 81
German - 1
Greek - 2
Italian - 2
Serbo-Croatian - 1
Vietnamese - 1

Programmer's Information

$country_code: AUS -
$search_char: A
TEST: $country_code: AUS
WHERE: WHERE LEFT(Code, 1) = 'A'
$country_code: AUS
$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: AUS
$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 = 'AUS' AND country.Capital = city.ID"
Country query returned 1 row

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

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

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