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

AUT - Austria

Continent: Europe
Region: Western Europe
Surface Area: 83,859 sq. km
Year of Independence: 1918
Population: 8,091,800
Life Expectancy: 77.7 years
GNP: $211,860 million
Local Name: Österreich
Form of Government: Federal Republic
Head of State: Thomas Klestil
Capital: Wien

AT flag

Major Cities
Name District Population
Graz Steiermark 240,967
Innsbruck Tiroli 111,752
Klagenfurt Kärnten 91,141
Linz North Austria 188,022
Salzburg Salzburg 144,247
Wien Wien 1,608,144
Languages
Language Status Percentage
Czech - 0
German Official 92
Hungarian - 0
Polish - 0
Romanian - 0
Serbo-Croatian - 2
Slovene - 0
Turkish - 2

Programmer's Information

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

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

Language query: "SELECT Language, IsOfficial, Percentage FROM countrylanguage WHERE CountryCode = 'AUT' 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.