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

Programmer's Information

$search_char: A
TEST: $country_code:
WHERE: WHERE LEFT(Code, 1) = 'A'
$country_code:
$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:
$country_name:
$search_char: A

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