countries drop down for registration

[kundera]

hello all
So 2 idéas :

firstable :
I have a sql countries table, and thinks that can be usefull for doing a countries dropdown in the registration page.
So there is 2 iso code, and don't thinks that it's nececary to get it,
but its com from a oscommerce table and didn't modify it.

secondly
I'am thinking that's possible to do a mod OSCommerce systeme and 4images for example for selling some pics online (maybe there are better way, but it's just an idea)
The concept : 4image using for managing pics , and oscommerce for selling why the selling systeme is very good.
It will be interesant for people who want to do a website like corbis.com or digitalvision.
i give for people who are interested the website of OScommerce : http://www.oscommerce.com

Sorry for my bad english
so there is the sql table for country

Code: [Select]



#
# Structure de la table `countries`
#
# Création: Jeudi 27 Mars 2003 à 10:54
# Dernière modification: Jeudi 27 Mars 2003 à 10:54
#

CREATE TABLE `countries` (
  `countries_id` int(11) NOT NULL auto_increment,
  `countries_name` varchar(64) NOT NULL default '',
  `countries_iso_code_2` char(2) NOT NULL default '',
  `countries_iso_code_3` char(3) NOT NULL default '',
  `address_format_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`countries_id`),
  KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) TYPE=MyISAM AUTO_INCREMENT=240 ;

#
# Contenu de la table `countries`
#

INSERT INTO `countries` VALUES (1, 'Afghanistan', 'AF', 'AFG', 1);
INSERT INTO `countries` VALUES (2, 'Albania', 'AL', 'ALB', 1);
INSERT INTO `countries` VALUES (3, 'Algeria', 'DZ', 'DZA', 1);
INSERT INTO `countries` VALUES (4, 'American Samoa', 'AS', 'ASM', 1);
INSERT INTO `countries` VALUES (5, 'Andorra', 'AD', 'AND', 1);
INSERT INTO `countries` VALUES (6, 'Angola', 'AO', 'AGO', 1);
INSERT INTO `countries` VALUES (7, 'Anguilla', 'AI', 'AIA', 1);
INSERT INTO `countries` VALUES (8, 'Antarctica', 'AQ', 'ATA', 1);
INSERT INTO `countries` VALUES (9, 'Antigua and Barbuda', 'AG', 'ATG', 1);
INSERT INTO `countries` VALUES (10, 'Argentina', 'AR', 'ARG', 1);
INSERT INTO `countries` VALUES (11, 'Armenia', 'AM', 'ARM', 1);
INSERT INTO `countries` VALUES (12, 'Aruba', 'AW', 'ABW', 1);
INSERT INTO `countries` VALUES (13, 'Australia', 'AU', 'AUS', 1);
INSERT INTO `countries` VALUES (14, 'Austria', 'AT', 'AUT', 5);
INSERT INTO `countries` VALUES (15, 'Azerbaijan', 'AZ', 'AZE', 1);
INSERT INTO `countries` VALUES (16, 'Bahamas', 'BS', 'BHS', 1);
INSERT INTO `countries` VALUES (17, 'Bahrain', 'BH', 'BHR', 1);
INSERT INTO `countries` VALUES (18, 'Bangladesh', 'BD', 'BGD', 1);
INSERT INTO `countries` VALUES (19, 'Barbados', 'BB', 'BRB', 1);
INSERT INTO `countries` VALUES (20, 'Belarus', 'BY', 'BLR', 1);
INSERT INTO `countries` VALUES (21, 'Belgium', 'BE', 'BEL', 1);
INSERT INTO `countries` VALUES (22, 'Belize', 'BZ', 'BLZ', 1);
INSERT INTO `countries` VALUES (23, 'Benin', 'BJ', 'BEN', 1);
INSERT INTO `countries` VALUES (24, 'Bermuda', 'BM', 'BMU', 1);
INSERT INTO `countries` VALUES (25, 'Bhutan', 'BT', 'BTN', 1);
INSERT INTO `countries` VALUES (26, 'Bolivia', 'BO', 'BOL', 1);
INSERT INTO `countries` VALUES (27, 'Bosnia and Herzegowina', 'BA', 'BIH', 1);
INSERT INTO `countries` VALUES (28, 'Botswana', 'BW', 'BWA', 1);
INSERT INTO `countries` VALUES (29, 'Bouvet Island', 'BV', 'BVT', 1);
INSERT INTO `countries` VALUES (30, 'Brazil', 'BR', 'BRA', 1);
INSERT INTO `countries` VALUES (31, 'British Indian Ocean Territory', 'IO', 'IOT', 1);
INSERT INTO `countries` VALUES (32, 'Brunei Darussalam', 'BN', 'BRN', 1);
INSERT INTO `countries` VALUES (33, 'Bulgaria', 'BG', 'BGR', 1);
INSERT INTO `countries` VALUES (34, 'Burkina Faso', 'BF', 'BFA', 1);
INSERT INTO `countries` VALUES (35, 'Burundi', 'BI', 'BDI', 1);
INSERT INTO `countries` VALUES (36, 'Cambodia', 'KH', 'KHM', 1);
INSERT INTO `countries` VALUES (37, 'Cameroon', 'CM', 'CMR', 1);
INSERT INTO `countries` VALUES (38, 'Canada', 'CA', 'CAN', 1);
INSERT INTO `countries` VALUES (39, 'Cape Verde', 'CV', 'CPV', 1);
INSERT INTO `countries` VALUES (40, 'Cayman Islands', 'KY', 'CYM', 1);
INSERT INTO `countries` VALUES (41, 'Central African Republic', 'CF', 'CAF', 1);
INSERT INTO `countries` VALUES (42, 'Chad', 'TD', 'TCD', 1);
INSERT INTO `countries` VALUES (43, 'Chile', 'CL', 'CHL', 1);
INSERT INTO `countries` VALUES (44, 'China', 'CN', 'CHN', 1);
INSERT INTO `countries` VALUES (45, 'Christmas Island', 'CX', 'CXR', 1);
INSERT INTO `countries` VALUES (46, 'Cocos (Keeling) Islands', 'CC', 'CCK', 1);
INSERT INTO `countries` VALUES (47, 'Colombia', 'CO', 'COL', 1);
INSERT INTO `countries` VALUES (48, 'Comoros', 'KM', 'COM', 1);
INSERT INTO `countries` VALUES (49, 'Congo', 'CG', 'COG', 1);
INSERT INTO `countries` VALUES (50, 'Cook Islands', 'CK', 'COK', 1);
INSERT INTO `countries` VALUES (51, 'Costa Rica', 'CR', 'CRI', 1);
INSERT INTO `countries` VALUES (52, 'Cote D\'Ivoire', 'CI', 'CIV', 1);
INSERT INTO `countries` VALUES (53, 'Croatia', 'HR', 'HRV', 1);
INSERT INTO `countries` VALUES (54, 'Cuba', 'CU', 'CUB', 1);
INSERT INTO `countries` VALUES (55, 'Cyprus', 'CY', 'CYP', 1);
INSERT INTO `countries` VALUES (56, 'Czech Republic', 'CZ', 'CZE', 1);
INSERT INTO `countries` VALUES (57, 'Denmark', 'DK', 'DNK', 1);
INSERT INTO `countries` VALUES (58, 'Djibouti', 'DJ', 'DJI', 1);
INSERT INTO `countries` VALUES (59, 'Dominica', 'DM', 'DMA', 1);
INSERT INTO `countries` VALUES (60, 'Dominican Republic', 'DO', 'DOM', 1);
INSERT INTO `countries` VALUES (61, 'East Timor', 'TP', 'TMP', 1);
INSERT INTO `countries` VALUES (62, 'Ecuador', 'EC', 'ECU', 1);
INSERT INTO `countries` VALUES (63, 'Egypt', 'EG', 'EGY', 1);
INSERT INTO `countries` VALUES (64, 'El Salvador', 'SV', 'SLV', 1);
INSERT INTO `countries` VALUES (65, 'Equatorial Guinea', 'GQ', 'GNQ', 1);
INSERT INTO `countries` VALUES (66, 'Eritrea', 'ER', 'ERI', 1);
INSERT INTO `countries` VALUES (67, 'Estonia', 'EE', 'EST', 1);
INSERT INTO `countries` VALUES (68, 'Ethiopia', 'ET', 'ETH', 1);
INSERT INTO `countries` VALUES (69, 'Falkland Islands (Malvinas)', 'FK', 'FLK', 1);
INSERT INTO `countries` VALUES (70, 'Faroe Islands', 'FO', 'FRO', 1);
INSERT INTO `countries` VALUES (71, 'Fiji', 'FJ', 'FJI', 1);
INSERT INTO `countries` VALUES (72, 'Finland', 'FI', 'FIN', 1);
INSERT INTO `countries` VALUES (73, 'France', 'FR', 'FRA', 1);
INSERT INTO `countries` VALUES (74, 'France, Metropolitan', 'FX', 'FXX', 1);
INSERT INTO `countries` VALUES (75, 'French Guiana', 'GF', 'GUF', 1);
INSERT INTO `countries` VALUES (76, 'French Polynesia', 'PF', 'PYF', 1);
INSERT INTO `countries` VALUES (77, 'French Southern Territories', 'TF', 'ATF', 1);
INSERT INTO `countries` VALUES (78, 'Gabon', 'GA', 'GAB', 1);
INSERT INTO `countries` VALUES (79, 'Gambia', 'GM', 'GMB', 1);
INSERT INTO `countries` VALUES (80, 'Georgia', 'GE', 'GEO', 1);
INSERT INTO `countries` VALUES (81, 'Germany', 'DE', 'DEU', 5);
INSERT INTO `countries` VALUES (82, 'Ghana', 'GH', 'GHA', 1);
INSERT INTO `countries` VALUES (83, 'Gibraltar', 'GI', 'GIB', 1);
INSERT INTO `countries` VALUES (84, 'Greece', 'GR', 'GRC', 1);
INSERT INTO `countries` VALUES (85, 'Greenland', 'GL', 'GRL', 1);
INSERT INTO `countries` VALUES (86, 'Grenada', 'GD', 'GRD', 1);
INSERT INTO `countries` VALUES (87, 'Guadeloupe', 'GP', 'GLP', 1);
INSERT INTO `countries` VALUES (88, 'Guam', 'GU', 'GUM', 1);
INSERT INTO `countries` VALUES (89, 'Guatemala', 'GT', 'GTM', 1);
INSERT INTO `countries` VALUES (90, 'Guinea', 'GN', 'GIN', 1);
INSERT INTO `countries` VALUES (91, 'Guinea-bissau', 'GW', 'GNB', 1);
INSERT INTO `countries` VALUES (92, 'Guyana', 'GY', 'GUY', 1);
INSERT INTO `countries` VALUES (93, 'Haiti', 'HT', 'HTI', 1);
INSERT INTO `countries` VALUES (94, 'Heard and Mc Donald Islands', 'HM', 'HMD', 1);
INSERT INTO `countries` VALUES (95, 'Honduras', 'HN', 'HND', 1);
INSERT INTO `countries` VALUES (96, 'Hong Kong', 'HK', 'HKG', 1);
INSERT INTO `countries` VALUES (97, 'Hungary', 'HU', 'HUN', 1);
INSERT INTO `countries` VALUES (98, 'Iceland', 'IS', 'ISL', 1);
INSERT INTO `countries` VALUES (99, 'India', 'IN', 'IND', 1);
INSERT INTO `countries` VALUES (100, 'Indonesia', 'ID', 'IDN', 1);
INSERT INTO `countries` VALUES (101, 'Iran (Islamic Republic of)', 'IR', 'IRN', 1);
INSERT INTO `countries` VALUES (102, 'Iraq', 'IQ', 'IRQ', 1);
INSERT INTO `countries` VALUES (103, 'Ireland', 'IE', 'IRL', 1);
INSERT INTO `countries` VALUES (104, 'Israel', 'IL', 'ISR', 1);
INSERT INTO `countries` VALUES (105, 'Italy', 'IT', 'ITA', 1);
INSERT INTO `countries` VALUES (106, 'Jamaica', 'JM', 'JAM', 1);
INSERT INTO `countries` VALUES (107, 'Japan', 'JP', 'JPN', 1);
INSERT INTO `countries` VALUES (108, 'Jordan', 'JO', 'JOR', 1);
INSERT INTO `countries` VALUES (109, 'Kazakhstan', 'KZ', 'KAZ', 1);
INSERT INTO `countries` VALUES (110, 'Kenya', 'KE', 'KEN', 1);
INSERT INTO `countries` VALUES (111, 'Kiribati', 'KI', 'KIR', 1);
INSERT INTO `countries` VALUES (112, 'Korea, Democratic People\'s Republic of', 'KP', 'PRK', 1);
INSERT INTO `countries` VALUES (113, 'Korea, Republic of', 'KR', 'KOR', 1);
INSERT INTO `countries` VALUES (114, 'Kuwait', 'KW', 'KWT', 1);
INSERT INTO `countries` VALUES (115, 'Kyrgyzstan', 'KG', 'KGZ', 1);
INSERT INTO `countries` VALUES (116, 'Lao People\'s Democratic Republic', 'LA', 'LAO', 1);
INSERT INTO `countries` VALUES (117, 'Latvia', 'LV', 'LVA', 1);
INSERT INTO `countries` VALUES (118, 'Lebanon', 'LB', 'LBN', 1);
INSERT INTO `countries` VALUES (119, 'Lesotho', 'LS', 'LSO', 1);
INSERT INTO `countries` VALUES (120, 'Liberia', 'LR', 'LBR', 1);
INSERT INTO `countries` VALUES (121, 'Libyan Arab Jamahiriya', 'LY', 'LBY', 1);
INSERT INTO `countries` VALUES (122, 'Liechtenstein', 'LI', 'LIE', 1);
INSERT INTO `countries` VALUES (123, 'Lithuania', 'LT', 'LTU', 1);
INSERT INTO `countries` VALUES (124, 'Luxembourg', 'LU', 'LUX', 1);
INSERT INTO `countries` VALUES (125, 'Macau', 'MO', 'MAC', 1);
INSERT INTO `countries` VALUES (126, 'Macedonia, The Former Yugoslav Republic of', 'MK', 'MKD', 1);
INSERT INTO `countries` VALUES (127, 'Madagascar', 'MG', 'MDG', 1);
INSERT INTO `countries` VALUES (128, 'Malawi', 'MW', 'MWI', 1);
INSERT INTO `countries` VALUES (129, 'Malaysia', 'MY', 'MYS', 1);
INSERT INTO `countries` VALUES (130, 'Maldives', 'MV', 'MDV', 1);
INSERT INTO `countries` VALUES (131, 'Mali', 'ML', 'MLI', 1);
INSERT INTO `countries` VALUES (132, 'Malta', 'MT', 'MLT', 1);
INSERT INTO `countries` VALUES (133, 'Marshall Islands', 'MH', 'MHL', 1);
INSERT INTO `countries` VALUES (134, 'Martinique', 'MQ', 'MTQ', 1);
INSERT INTO `countries` VALUES (135, 'Mauritania', 'MR', 'MRT', 1);
INSERT INTO `countries` VALUES (136, 'Mauritius', 'MU', 'MUS', 1);
INSERT INTO `countries` VALUES (137, 'Mayotte', 'YT', 'MYT', 1);
INSERT INTO `countries` VALUES (138, 'Mexico', 'MX', 'MEX', 1);
INSERT INTO `countries` VALUES (139, 'Micronesia, Federated States of', 'FM', 'FSM', 1);
INSERT INTO `countries` VALUES (140, 'Moldova, Republic of', 'MD', 'MDA', 1);
INSERT INTO `countries` VALUES (141, 'Monaco', 'MC', 'MCO', 1);
INSERT INTO `countries` VALUES (142, 'Mongolia', 'MN', 'MNG', 1);
INSERT INTO `countries` VALUES (143, 'Montserrat', 'MS', 'MSR', 1);
INSERT INTO `countries` VALUES (144, 'Morocco', 'MA', 'MAR', 1);
INSERT INTO `countries` VALUES (145, 'Mozambique', 'MZ', 'MOZ', 1);
INSERT INTO `countries` VALUES (146, 'Myanmar', 'MM', 'MMR', 1);
INSERT INTO `countries` VALUES (147, 'Namibia', 'NA', 'NAM', 1);
INSERT INTO `countries` VALUES (148, 'Nauru', 'NR', 'NRU', 1);
INSERT INTO `countries` VALUES (149, 'Nepal', 'NP', 'NPL', 1);
INSERT INTO `countries` VALUES (150, 'Netherlands', 'NL', 'NLD', 1);
INSERT INTO `countries` VALUES (151, 'Netherlands Antilles', 'AN', 'ANT', 1);
INSERT INTO `countries` VALUES (152, 'New Caledonia', 'NC', 'NCL', 1);
INSERT INTO `countries` VALUES (153, 'New Zealand', 'NZ', 'NZL', 1);
INSERT INTO `countries` VALUES (154, 'Nicaragua', 'NI', 'NIC', 1);
INSERT INTO `countries` VALUES (155, 'Niger', 'NE', 'NER', 1);
INSERT INTO `countries` VALUES (156, 'Nigeria', 'NG', 'NGA', 1);
INSERT INTO `countries` VALUES (157, 'Niue', 'NU', 'NIU', 1);
INSERT INTO `countries` VALUES (158, 'Norfolk Island', 'NF', 'NFK', 1);
INSERT INTO `countries` VALUES (159, 'Northern Mariana Islands', 'MP', 'MNP', 1);
INSERT INTO `countries` VALUES (160, 'Norway', 'NO', 'NOR', 1);
INSERT INTO `countries` VALUES (161, 'Oman', 'OM', 'OMN', 1);
INSERT INTO `countries` VALUES (162, 'Pakistan', 'PK', 'PAK', 1);
INSERT INTO `countries` VALUES (163, 'Palau', 'PW', 'PLW', 1);
INSERT INTO `countries` VALUES (164, 'Panama', 'PA', 'PAN', 1);
INSERT INTO `countries` VALUES (165, 'Papua New Guinea', 'PG', 'PNG', 1);
INSERT INTO `countries` VALUES (166, 'Paraguay', 'PY', 'PRY', 1);
INSERT INTO `countries` VALUES (167, 'Peru', 'PE', 'PER', 1);
INSERT INTO `countries` VALUES (168, 'Philippines', 'PH', 'PHL', 1);
INSERT INTO `countries` VALUES (169, 'Pitcairn', 'PN', 'PCN', 1);
INSERT INTO `countries` VALUES (170, 'Poland', 'PL', 'POL', 1);
INSERT INTO `countries` VALUES (171, 'Portugal', 'PT', 'PRT', 1);
INSERT INTO `countries` VALUES (172, 'Puerto Rico', 'PR', 'PRI', 1);
INSERT INTO `countries` VALUES (173, 'Qatar', 'QA', 'QAT', 1);
INSERT INTO `countries` VALUES (174, 'Reunion', 'RE', 'REU', 1);
INSERT INTO `countries` VALUES (175, 'Romania', 'RO', 'ROM', 1);
INSERT INTO `countries` VALUES (176, 'Russian Federation', 'RU', 'RUS', 1);
INSERT INTO `countries` VALUES (177, 'Rwanda', 'RW', 'RWA', 1);
INSERT INTO `countries` VALUES (178, 'Saint Kitts and Nevis', 'KN', 'KNA', 1);
INSERT INTO `countries` VALUES (179, 'Saint Lucia', 'LC', 'LCA', 1);
INSERT INTO `countries` VALUES (180, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 1);
INSERT INTO `countries` VALUES (181, 'Samoa', 'WS', 'WSM', 1);
INSERT INTO `countries` VALUES (182, 'San Marino', 'SM', 'SMR', 1);
INSERT INTO `countries` VALUES (183, 'Sao Tome and Principe', 'ST', 'STP', 1);
INSERT INTO `countries` VALUES (184, 'Saudi Arabia', 'SA', 'SAU', 1);
INSERT INTO `countries` VALUES (185, 'Senegal', 'SN', 'SEN', 1);
INSERT INTO `countries` VALUES (186, 'Seychelles', 'SC', 'SYC', 1);
INSERT INTO `countries` VALUES (187, 'Sierra Leone', 'SL', 'SLE', 1);
INSERT INTO `countries` VALUES (188, 'Singapore', 'SG', 'SGP', 4);
INSERT INTO `countries` VALUES (189, 'Slovakia (Slovak Republic)', 'SK', 'SVK', 1);
INSERT INTO `countries` VALUES (190, 'Slovenia', 'SI', 'SVN', 1);
INSERT INTO `countries` VALUES (191, 'Solomon Islands', 'SB', 'SLB', 1);
INSERT INTO `countries` VALUES (192, 'Somalia', 'SO', 'SOM', 1);
INSERT INTO `countries` VALUES (193, 'South Africa', 'ZA', 'ZAF', 1);
INSERT INTO `countries` VALUES (194, 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 1);
INSERT INTO `countries` VALUES (195, 'Spain', 'ES', 'ESP', 3);
INSERT INTO `countries` VALUES (196, 'Sri Lanka', 'LK', 'LKA', 1);
INSERT INTO `countries` VALUES (197, 'St. Helena', 'SH', 'SHN', 1);
INSERT INTO `countries` VALUES (198, 'St. Pierre and Miquelon', 'PM', 'SPM', 1);
INSERT INTO `countries` VALUES (199, 'Sudan', 'SD', 'SDN', 1);
INSERT INTO `countries` VALUES (200, 'Suriname', 'SR', 'SUR', 1);
INSERT INTO `countries` VALUES (201, 'Svalbard and Jan Mayen Islands', 'SJ', 'SJM', 1);
INSERT INTO `countries` VALUES (202, 'Swaziland', 'SZ', 'SWZ', 1);
INSERT INTO `countries` VALUES (203, 'Sweden', 'SE', 'SWE', 1);
INSERT INTO `countries` VALUES (204, 'Switzerland', 'CH', 'CHE', 1);
INSERT INTO `countries` VALUES (205, 'Syrian Arab Republic', 'SY', 'SYR', 1);
INSERT INTO `countries` VALUES (206, 'Taiwan', 'TW', 'TWN', 1);
INSERT INTO `countries` VALUES (207, 'Tajikistan', 'TJ', 'TJK', 1);
INSERT INTO `countries` VALUES (208, 'Tanzania, United Republic of', 'TZ', 'TZA', 1);
INSERT INTO `countries` VALUES (209, 'Thailand', 'TH', 'THA', 1);
INSERT INTO `countries` VALUES (210, 'Togo', 'TG', 'TGO', 1);
INSERT INTO `countries` VALUES (211, 'Tokelau', 'TK', 'TKL', 1);
INSERT INTO `countries` VALUES (212, 'Tonga', 'TO', 'TON', 1);
INSERT INTO `countries` VALUES (213, 'Trinidad and Tobago', 'TT', 'TTO', 1);
INSERT INTO `countries` VALUES (214, 'Tunisia', 'TN', 'TUN', 1);
INSERT INTO `countries` VALUES (215, 'Turkey', 'TR', 'TUR', 1);
INSERT INTO `countries` VALUES (216, 'Turkmenistan', 'TM', 'TKM', 1);
INSERT INTO `countries` VALUES (217, 'Turks and Caicos Islands', 'TC', 'TCA', 1);
INSERT INTO `countries` VALUES (218, 'Tuvalu', 'TV', 'TUV', 1);
INSERT INTO `countries` VALUES (219, 'Uganda', 'UG', 'UGA', 1);
INSERT INTO `countries` VALUES (220, 'Ukraine', 'UA', 'UKR', 1);
INSERT INTO `countries` VALUES (221, 'United Arab Emirates', 'AE', 'ARE', 1);
INSERT INTO `countries` VALUES (222, 'United Kingdom', 'GB', 'GBR', 1);
INSERT INTO `countries` VALUES (223, 'United States', 'US', 'USA', 2);
INSERT INTO `countries` VALUES (224, 'United States Minor Outlying Islands', 'UM', 'UMI', 1);
INSERT INTO `countries` VALUES (225, 'Uruguay', 'UY', 'URY', 1);
INSERT INTO `countries` VALUES (226, 'Uzbekistan', 'UZ', 'UZB', 1);
INSERT INTO `countries` VALUES (227, 'Vanuatu', 'VU', 'VUT', 1);
INSERT INTO `countries` VALUES (228, 'Vatican City State (Holy See)', 'VA', 'VAT', 1);
INSERT INTO `countries` VALUES (229, 'Venezuela', 'VE', 'VEN', 1);
INSERT INTO `countries` VALUES (230, 'Viet Nam', 'VN', 'VNM', 1);
INSERT INTO `countries` VALUES (231, 'Virgin Islands (British)', 'VG', 'VGB', 1);
INSERT INTO `countries` VALUES (232, 'Virgin Islands (U.S.)', 'VI', 'VIR', 1);
INSERT INTO `countries` VALUES (233, 'Wallis and Futuna Islands', 'WF', 'WLF', 1);
INSERT INTO `countries` VALUES (234, 'Western Sahara', 'EH', 'ESH', 1);
INSERT INTO `countries` VALUES (235, 'Yemen', 'YE', 'YEM', 1);
INSERT INTO `countries` VALUES (236, 'Yugoslavia', 'YU', 'YUG', 1);
INSERT INTO `countries` VALUES (237, 'Zaire', 'ZR', 'ZAR', 1);
INSERT INTO `countries` VALUES (238, 'Zambia', 'ZM', 'ZMB', 1);
INSERT INTO `countries` VALUES (239, 'Zimbabwe', 'ZW', 'ZWE', 1);



[kundera]

it's a good way?







CREATE IN LANG folder a file countries.php
///////////////////////////////////////////////////////

Code: [Select]

<?php
$lang['countries'&#93; = "<option value='FR'>France</option><option value='SZ'>Suisse</option><option value='BE'>Belgique</option><option value=''><hr></option><option value='AF'>Afghanistan</option><option value='SF'>Afrique&nbsp;du&nbsp;Sud</option><option value='AL'>Albanie</option><option value='AG'>Alg&eacute;rie</option><option value='GM'>Allemagne</option><option value='AN'>Andorre</option><option value='AO'>Angola</option><option value='AV'>Anguilla</option><option value='AC'>Antigua-et-Barbuda</option><option value='NT'>Antilles&nbsp;N&eacute;&eacute;rlandaises</option><option value='SA'>Arabie&nbsp;Saoudite</option><option value='AR'>Argentine</option><option value='AM'>Arm&eacute;nie</option><option value='AA'>Aruba</option><option value='AS'>Australie</option><option value='AU'>Autriche</option><option value='AJ'>Azerbaidjan</option><option value='BF'>Bahamas</option><option value='BA'>Bahrein</option><option value='GZ'>Bande&nbsp;de&nbsp;Gaza</option><option value='BG'>Bangladesh</option><option value='BB'>Barbade</option><option value='BO'>B&eacute;larus</option><option value='BE'>Belgique</option><option value='BH'>Belize</option><option value='BN'>B&eacute;nin</option><option value='BD'>Bermudes</option><option value='BT'>Bhoutan</option><option value='BL'>Bolivie</option><option value='BK'>Bosnie-Herz&eacute;govine</option><option value='BC'>Botswana</option><option value='BR'>Br&eacute;sil</option><option value='BX'>Brunei&nbsp;Darussalam</option><option value='BU'>Bulgarie</option><option value='UV'>Burkina&nbsp;Faso</option><option value='BY'>Burundi</option><option value='CB'>Cambodge</option><option value='CM'>Cameroun</option><option value='CA'>Canada</option><option value='CV'>Cap&nbsp;Vert</option><option value='CI'>Chili</option><option value='CH'>Chine</option><option value='CY'>Chypre</option><option value='WE'>Cisjordanie</option><option value='CO'>Colombie</option><option value='CN'>Comores</option><option value='CF'>Congo</option><option value='CW'>Cook&nbsp;Islands</option><option value='CS'>Costa&nbsp;Rica</option><option value='IV'>C&ocirc;te&nbsp;d’Ivoire</option><option value='HR'>Croatie</option><option value='CU'>Cuba</option><option value='DA'>Danemark</option><option value='DJ'>Djibouti</option><option value='DO'>Dominique</option><option value='EG'>Egypte</option><option value='ES'>El&nbsp;Salvador</option><option value='AE'>Emirats&nbsp;Arabes&nbsp;Unis</option><option value='EC'>Equateur</option><option value='ER'>Erythree</option><option value='SP'>Espagne</option><option value='EN'>Estonie</option><option value='US'>Etats-Unis</option><option value='ET'>Ethiopie</option><option value='FJ'>Fidji</option><option value='FI'>Finlande</option><option value='FR'>France</option><option value='GB'>Gabon</option><option value='GA'>Gambie</option><option value='GG'>G&eacute;orgie</option><option value='GH'>Ghana</option><option value='GI'>Gibraltar</option><option value='GR'>Gr&egrave;ce</option><option value='GJ'>Grenade</option><option value='GL'>Groenland</option><option value='GP'>Guadeloupe</option><option value='GT'>Guatemala</option><option value='GK'>Guernesey</option><option value='GV'>Guin&eacute;e</option><option value='PU'>Guin&eacute;e-Bissau</option><option value='EK'>Guin&eacute;e&nbsp;&eacute;quatoriale</option><option value='FG'>Guyane</option><option value='GY'>Guyane</option><option value='HA'>Haiti</option><option value='HO'>Honduras</option><option value='HK'>Hong-Kong</option><option value='HU'>Hongrie</option><option value='IM'>Ile&nbsp;de&nbsp;Man</option><option value='CJ'>Iles&nbsp;Caiman</option><option value='KT'>Iles&nbsp;Christmas</option><option value='CK'>Iles&nbsp;Cocos</option><option value='SX'>Iles&nbsp;de&nbsp;G&eacute;orgie&nbsp;du&nbsp;Sud&nbsp;et&nbsp;Iles&nbsp;Sandwich</option><option value='FK'>Iles&nbsp;Falkland</option><option value='FO'>Iles&nbsp;F&eacute;ro&eacute;</option><option value='RM'>Iles&nbsp;Marshall</option><option value='PC'>Iles&nbsp;Pitcairns</option><option value='BP'>Iles&nbsp;Solomon</option><option value='PG'>Iles&nbsp;Spratly</option><option value='TK'>Iles&nbsp;Turks&nbsp;et&nbsp;Caicos</option><option value='VI'>Iles&nbsp;Vierges</option><option value='IN'>Inde</option><option value='ID'>Indon&eacute;sie</option><option value='IR'>Iran</option><option value='IZ'>Iraq</option><option value='EI'>Irlande</option><option value='IC'>Islande</option><option value='IS'>Israel</option><option value='IT'>Italie</option><option value='JM'>Jamaique</option><option value='JA'>Japon</option><option value='JE'>Jersey</option><option value='JO'>Jordanie</option><option value='KZ'>Kazakhstan</option><option value='KE'>Kenya</option><option value='KG'>Kirghizistan</option><option value='KR'>Kiribati</option><option value='KU'>Koweit</option><option value='LA'>Laos</option><option value='LT'>Lesotho</option><option value='LG'>Lettonie</option><option value='LE'>Liban</option><option value='LI'>Liberia</option><option value='LY'>Libye</option><option value='LS'>Liechtenstein</option><option value='LH'>Lituanie</option><option value='LU'>Luxembourg</option><option value='MC'>Macao</option><option value='MK'>Mac&eacute;doine</option><option value='MA'>Madagascar</option><option value='MY'>Malaisie</option><option value='MI'>Malawi</option><option value='MV'>Maldives</option><option value='ML'>Mali</option><option value='MT'>Malte</option><option value='MO'>Maroc</option><option value='MB'>Martinique</option><option value='MP'>Maurice</option><option value='MR'>Mauritanie</option><option value='MF'>Mayotte</option><option value='MX'>Mexique</option><option value='FM'>Micron&eacute;sie</option><option value='MD'>Moldova</option><option value='MN'>Monaco</option><option value='MG'>Mongolie</option><option value='MH'>Montserrat</option><option value='MZ'>Mozambique</option><option value='BM'>Myanmar</option><option value='WA'>Namibie</option><option value='NR'>Nauru</option><option value='NP'>N&eacute;pal</option><option value='NU'>Nicaragua</option><option value='NG'>Niger</option><option value='NI'>Nig&eacute;ria</option><option value='NE'>Niue</option><option value='NM'>No&nbsp;Man’s&nbsp;Land</option><option value='NF'>Norfolk&nbsp;Island</option><option value='NO'>Norv&egrave;ge</option><option value='NC'>Nouvelle-Cal&eacute;donie</option><option value='NZ'>Nouvelle-Z&eacute;lande</option><option value='MU'>Oman</option><option value='UG'>Ouganda</option><option value='UZ'>Ouzb&eacute;kistan</option><option value='PK'>Pakistan</option><option value='PS'>Palaos</option><option value='PM'>Panama</option><option value='PP'>Papouasie-Nouvelle-Guin&eacute;e</option><option value='PA'>Paraguay</option><option value='NL'>Pays-Bas</option><option value='PE'>P&eacute;rou</option><option value='RP'>Philippines</option><option value='PL'>Pologne</option><option value='FP'>Polyn&eacute;sie&nbsp;Fran&ccedil;aise</option><option value='PR'>Porto Rico</option><option value='PO'>Portugal</option><option value='QA'>Qatar</option><option value='CT'>R&eacute;publique&nbsp;Centrafricaine</option><option value='KS'>R&eacute;publique&nbsp;de&nbsp;Cor&eacute;e</option><option value='CG'>R&eacute;publique&nbsp;d&eacute;mocratique&nbsp;du&nbsp;Congo</option><option value='DR'>R&eacute;publique&nbsp;dominicaine</option><option value='KN'>R&eacute;publique&nbsp;populaire&nbsp;d&eacute;mocratique&nbsp;de&nbsp;Cor&eacute;e</option><option value='LO'>R&eacute;publique&nbsp;Slovaque</option><option value='EZ'>R&eacute;publique&nbsp;Tch&egrave;que</option><option value='RE'>R&eacute;union</option><option value='RO'>Roumanie</option><option value='UK'>Royaume-Uni</option><option value='RS'>Russie</option><option value='RW'>Rwanda</option><option value='WI'>Sahara&nbsp;Occidental</option><option value='SH'>Sainte-H&eacute;l&egrave;ne</option><option value='ST'>Sainte-Lucie</option><option value='SC'>Saint-Kitts-et-Nevis</option><option value='SB'>Saint-Pierre-et-Miquelon</option><option value='VC'>Saint-Vincent&nbsp;et&nbsp;Grenadines</option><option value='WS'>Samoa</option><option value='SM'>San&nbsp;Marin</option><option value='TP'>Sao&nbsp;Tom&eacute;-et-Principe</option><option value='SG'>S&eacute;n&eacute;gal</option><option value='SE'>Seychelles</option><option value='SL'>Sierra&nbsp;Leone</option><option value='SN'>Singapour</option><option value='SI'>Slov&eacute;nie</option><option value='SO'>Somalie</option><option value='SU'>Soudan</option><option value='CE'>Sri&nbsp;Lanka</option><option value='SW'>Su&egrave;de</option><option value='SZ'>Suisse</option><option value='NS'>Suriname</option><option value='SV'>Svalbard</option><option value='WZ'>Swaziland</option><option value='SY'>Syrie</option><option value='TI'>Tadjikistan</option><option value='TW'>Taiwan</option><option value='TZ'>Tanzanie</option><option value='CD'>Tchad</option><option value='FS'>Terres&nbsp;Australes&nbsp;et&nbsp;Antarctiques&nbsp;Fran&ccedil;aises</option><option value='TH'>Thailande</option><option value='TT'>Timor&nbsp;Oriental</option><option value='TO'>Togo</option><option value='TL'>Tokelau</option><option value='TN'>Tonga</option><option value='TD'>Trinit&eacute;&nbsp;et&nbsp;Tobago</option><option value='TS'>Tunisie</option><option value='TX'>Turkm&eacute;nistan</option><option value='TU'>Turquie</option><option value='TV'>Tuvalu</option><option value='UP'>Ukraine</option><option value='UY'>Uruguay</option><option value='NH'>Vanuatu</option><option value='VE'>V&eacute;n&eacute;zuela</option><option value='VM'>Viet&nbsp;Nam</option><option value='WF'>Wallis&nbsp;et&nbsp;Futuna</option><option value='YM'>Y&eacute;men</option><option value='YI'>Yougoslavie</option><option value='ZA'>Zambie</option><option value='ZI'>Zimbabwe</option>";

?>

(without blank)


in register.php//
AFTER :
///////////////////////////////////////////////////////////

Code: [Select]

include(ROOT_PATH.'includes/page_header.php');

add :
///////////////////////////////////////////////////////////

Code: [Select]

require(ROOT_PATH.'lang/countries.php');

AFTER :
///////////////////////////////////////////////////////////

Code: [Select]

"lang_email" => $lang['email'],

add :
///////////////////////////////////////////////////////////

Code: [Select]

"countries" => $lang['countries'],




in template/default/register_form.html
ADD : (where you want to show your dropdown menu)
///////////////////////////////////////////////////////////

Code: [Select]

<select name="countries">{countries}</select>


in includes/db_fields_definition.php
BEFORE :
///////////////////////////////////////////////////////////

Code: [Select]

?>

ADD :
///////////////////////////////////////////////////////////

Code: [Select]

$additional_user_fields['countries'] = array($lang['countries'], "text", 1);

and insert a sql row in your db_user
That's right or there is a better way or somes mistakes?

[/code]

[V@no]

well, u can make the code 3 times smaller if u use just array for countries and then generate <option...> from it.

[Sheep707]

 The short form of Switzerland (Suisse) isn't SZ!!!!!!!! It's CH (converderale helvetica)

[schizo]

i cant seem to make this work... whats wrong???

[ascanio]

and insert a sql row in your db_user how do u do that?

[V@no]

use your favorite mysql manager. if u dont have one, then google one: phpmyadmin

[ascanio]

Thanks V@no I had Phpmyadmin but I have never used before and a friend of mine just explain me how to use it but I have some problems with this can u read this topic? http://www.4homepages.de/forum/index.php?topic=747.new#new