International country names database
MySQL table of all the country names in the world, from Afghanistan to Zimbabwe. Includes the ISO 2- and 3-character country codes.
countries.sql, 7.4Kb
A table of country names is indispensible when creating forms that require the user to input a country.
Using a table of country names not only ensures that all inputs are correctly spelled, it also makes form generation much simpler.
Using a few simple lines of PHP code, you can auto-generate a SELECT field with all the available country names. If the form has to be presented to the user again (e.g. if the form was incorrectly filled in), it is a simple matter to use the POST value to make the SELECT field automatically display the original user-submitted value.