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
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

| 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 |
| Language | Status | Percentage |
|---|---|---|
| Arabic | - | 1 |
| Canton Chinese | - | 1 |
| English | Official | 81 |
| German | - | 1 |
| Greek | - | 2 |
| Italian | - | 2 |
| Serbo-Croatian | - | 1 |
| Vietnamese | - | 1 |
$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.