Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Translated country names?


jerry1970

Recommended Posts

Hi all,

 

I have searched the documentation and forum, but couldn't find anything on this.

 

Is there an easy way to get a list of translated country names? All country names are in English now. Quite understandably, but I prefer to have them in Dutch.

 

I assume they're in a database table?

 

Thanks!

Jerry

Link to comment
Share on other sites

Do you want to completely replace the current (english) list in the db? If so, check back here tomorrow (Thursday) morning - I'll have something for you.

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. ~ Benjamin Franklin, 1759. տլ

Link to comment
Share on other sites

INSERT INTO `countries` VALUES (1, 'Amerikaanse Maagdeneilanden (U.S.)', 'VI', 'VIR', 1);
INSERT INTO `countries` VALUES (2, 'Amerikaanse ondergeschikte afgelegen eilanden', 'UM', 'UMI', 1);
INSERT INTO `countries` VALUES (3, 'Argentini?', 'AR', 'ARG', 1);
INSERT INTO `countries` VALUES (4, 'Armeni?', 'AM', 'ARM', 1);
INSERT INTO `countries` VALUES (5, 'Aruba', 'AW', 'ABW', 1);
INSERT INTO `countries` VALUES (6, 'Australi?', 'AU', 'AUS', 1);
INSERT INTO `countries` VALUES (7, 'Azerbeidzjan', 'AZ', 'AZE', 1);
INSERT INTO `countries` VALUES (8, 'Bahamas', 'BS', 'BHS', 1);
INSERT INTO `countries` VALUES (9, 'Bahrein', 'BH', 'BHR', 1);
INSERT INTO `countries` VALUES (10, 'Bangladesh', 'BD', 'BGD', 1);
INSERT INTO `countries` VALUES (11, 'Barbados', 'BB', 'BRB', 1);
INSERT INTO `countries` VALUES (12, 'Belarus', 'BY', 'BLR', 1);
INSERT INTO `countries` VALUES (13, 'Belgi?', 'BE', 'BEL', 1);
INSERT INTO `countries` VALUES (14, 'Belize', 'BZ', 'BLZ', 1);
INSERT INTO `countries` VALUES (15, 'Benin', 'BJ', 'BEN', 1);
INSERT INTO `countries` VALUES (16, 'Bermuda', 'BM', 'BMU', 1);
INSERT INTO `countries` VALUES (17, 'Bhutan', 'BT', 'BTN', 1);
INSERT INTO `countries` VALUES (18, 'Bolivia', 'BO', 'BOL', 1);
INSERT INTO `countries` VALUES (19, 'Bosni? en Herzegovina', 'BA', 'BIH', 1);
INSERT INTO `countries` VALUES (20, 'Botswana', 'BW', 'BWA', 1);
INSERT INTO `countries` VALUES (21, 'Bouveteiland', 'BV', 'BVT', 1);
INSERT INTO `countries` VALUES (22, 'Brazili?', 'BR', 'BRA', 1);
INSERT INTO `countries` VALUES (23, 'Brits Territorium in de Indische Oceaan', 'IO', 'IOT', 1);
INSERT INTO `countries` VALUES (24, 'Britse Maagdeneilanden', 'VG', 'VGB', 1);
INSERT INTO `countries` VALUES (25, 'Brunei', 'BN', 'BRN', 1);
INSERT INTO `countries` VALUES (26, 'Bulgarije', 'BG', 'BGR', 1);
INSERT INTO `countries` VALUES (27, 'Burkina Faso', 'BF', 'BFA', 1);
INSERT INTO `countries` VALUES (28, 'Burundi', 'BI', 'BDI', 1);
INSERT INTO `countries` VALUES (29, 'Cambodja', 'KH', 'KHM', 1);
INSERT INTO `countries` VALUES (30, 'Canada', 'CA', 'CAN', 1);
INSERT INTO `countries` VALUES (31, 'Caymaneilanden', 'KY', 'CYM', 1);
INSERT INTO `countries` VALUES (32, 'Centraal-Afrikaanse Republiek', 'CF', 'CAF', 1);
INSERT INTO `countries` VALUES (33, 'Chile', 'CL', 'CHL', 1);
INSERT INTO `countries` VALUES (34, 'China', 'CN', 'CHN', 1);
INSERT INTO `countries` VALUES (35, 'Christmaseiland', 'CX', 'CXR', 1);
INSERT INTO `countries` VALUES (36, 'Cocoseilanden', 'CC', 'CCK', 1);
INSERT INTO `countries` VALUES (37, 'Colombia', 'CO', 'COL', 1);
INSERT INTO `countries` VALUES (38, 'Comoren', 'KM', 'COM', 1);
INSERT INTO `countries` VALUES (39, 'Congo', 'CG', 'COG', 1);
INSERT INTO `countries` VALUES (40, 'Cookeilanden', 'CK', 'COK', 1);
INSERT INTO `countries` VALUES (41, 'Costa Rica', 'CR', 'CRI', 1);
INSERT INTO `countries` VALUES (42, 'Cuba', 'CU', 'CUB', 1);
INSERT INTO `countries` VALUES (43, 'Cyprus', 'CY', 'CYP', 1);
INSERT INTO `countries` VALUES (44, 'Denemarken', 'DK', 'DNK', 1);
INSERT INTO `countries` VALUES (45, 'Djibouti', 'DJ', 'DJI', 1);
INSERT INTO `countries` VALUES (46, 'Dominica', 'DM', 'DMA', 1);
INSERT INTO `countries` VALUES (47, 'Dominicaanse Republiek', 'DO', 'DOM', 1);
INSERT INTO `countries` VALUES (48, 'Duitsland', 'DE', 'DEU', 5);
INSERT INTO `countries` VALUES (49, 'Ecuador', 'EC', 'ECU', 1);
INSERT INTO `countries` VALUES (50, 'Egypte', 'EG', 'EGY', 1);
INSERT INTO `countries` VALUES (51, 'El Salvador', 'SV', 'SLV', 1);
INSERT INTO `countries` VALUES (52, 'Equatoriaal-Guinea', 'GQ', 'GNQ', 1);
INSERT INTO `countries` VALUES (53, 'Eritrea', 'ER', 'ERI', 1);
INSERT INTO `countries` VALUES (54, 'Estland', 'EE', 'EST', 1);
INSERT INTO `countries` VALUES (55, 'Ethiopi?', 'ET', 'ETH', 1);
INSERT INTO `countries` VALUES (56, 'Faer?er', 'FO', 'FRO', 1);
INSERT INTO `countries` VALUES (57, 'Falklandeilanden', 'FK', 'FLK', 1);
INSERT INTO `countries` VALUES (58, 'Afghanistan', 'AF', 'AFG', 1);
INSERT INTO `countries` VALUES (59, 'Fiji', 'FJ', 'FJI', 1);
INSERT INTO `countries` VALUES (60, 'Filipijnen', 'PH', 'PHL', 1);
INSERT INTO `countries` VALUES (61, 'Finland', 'FI', 'FIN', 1);
INSERT INTO `countries` VALUES (62, 'France, Metropolitan', 'FX', 'FXX', 1);
INSERT INTO `countries` VALUES (63, 'Frankrijk', 'FR', 'FRA', 1);
INSERT INTO `countries` VALUES (64, 'Franse Gebieden in de zuidelijke Indische Oceaan', 'TF', 'ATF', 1);
INSERT INTO `countries` VALUES (65, 'Frans-Guyana', 'GF', 'GUF', 1);
INSERT INTO `countries` VALUES (66, 'Frans-Polynesi?', 'PF', 'PYF', 1);
INSERT INTO `countries` VALUES (67, 'Gabon', 'GA', 'GAB', 1);
INSERT INTO `countries` VALUES (68, 'Gambia', 'GM', 'GMB', 1);
INSERT INTO `countries` VALUES (69, 'Georgi?', 'GE', 'GEO', 1);
INSERT INTO `countries` VALUES (70, 'Ghana', 'GH', 'GHA', 1);
INSERT INTO `countries` VALUES (71, 'Gibraltar', 'GI', 'GIB', 1);
INSERT INTO `countries` VALUES (72, 'Grenada', 'GD', 'GRD', 1);
INSERT INTO `countries` VALUES (73, 'Griekenland', 'GR', 'GRC', 1);
INSERT INTO `countries` VALUES (74, 'Groenland', 'GL', 'GRL', 1);
INSERT INTO `countries` VALUES (75, 'Guadeloupe', 'GP', 'GLP', 1);
INSERT INTO `countries` VALUES (76, 'Guam', 'GU', 'GUM', 1);
INSERT INTO `countries` VALUES (77, 'Guatemala', 'GT', 'GTM', 1);
INSERT INTO `countries` VALUES (78, 'Guinee', 'GN', 'GIN', 1);
INSERT INTO `countries` VALUES (79, 'Guinee-Bissau', 'GW', 'GNB', 1);
INSERT INTO `countries` VALUES (80, 'Guyana', 'GY', 'GUY', 1);
INSERT INTO `countries` VALUES (81, 'Ha?ti', 'HT', 'HTI', 1);
INSERT INTO `countries` VALUES (82, 'Heard en McDonaldeilanden', 'HM', 'HMD', 1);
INSERT INTO `countries` VALUES (83, 'Honduras', 'HN', 'HND', 1);
INSERT INTO `countries` VALUES (84, 'Hongarije', 'HU', 'HUN', 1);
INSERT INTO `countries` VALUES (85, 'Hongkong', 'HK', 'HKG', 1);
INSERT INTO `countries` VALUES (86, 'Ierland', 'IE', 'IRL', 1);
INSERT INTO `countries` VALUES (87, 'IJsland', 'IS', 'ISL', 1);
INSERT INTO `countries` VALUES (88, 'India', 'IN', 'IND', 1);
INSERT INTO `countries` VALUES (89, 'Indonesi?', 'ID', 'IDN', 1);
INSERT INTO `countries` VALUES (90, 'Irak', 'IQ', 'IRQ', 1);
INSERT INTO `countries` VALUES (91, 'Iran (Islamic Republic of)', 'IR', 'IRN', 1);
INSERT INTO `countries` VALUES (92, 'Isra?l', 'IL', 'ISR', 1);
INSERT INTO `countries` VALUES (93, 'Itali?', 'IT', 'ITA', 1);
INSERT INTO `countries` VALUES (94, 'Ivoorkust', 'CI', 'CIV', 1);
INSERT INTO `countries` VALUES (95, 'Jamaica', 'JM', 'JAM', 1);
INSERT INTO `countries` VALUES (96, 'Japan', 'JP', 'JPN', 1);
INSERT INTO `countries` VALUES (97, 'Jemen', 'YE', 'YEM', 1);
INSERT INTO `countries` VALUES (98, 'Joegoslavi?', 'YU', 'YUG', 1);
INSERT INTO `countries` VALUES (99, 'Jordani?', 'JO', 'JOR', 1);
INSERT INTO `countries` VALUES (100, 'Kaapverdi?', 'CV', 'CPV', 1);
INSERT INTO `countries` VALUES (101, 'Kameroen', 'CM', 'CMR', 1);
INSERT INTO `countries` VALUES (102, 'Kazachstan', 'KZ', 'KAZ', 1);
INSERT INTO `countries` VALUES (103, 'Kenia', 'KE', 'KEN', 1);
INSERT INTO `countries` VALUES (104, 'Kirgizi?', 'KG', 'KGZ', 1);
INSERT INTO `countries` VALUES (105, 'Kiribati', 'KI', 'KIR', 1);
INSERT INTO `countries` VALUES (106, 'Koeweit', 'KW', 'KWT', 1);
INSERT INTO `countries` VALUES (107, 'Kroati?', 'HR', 'HRV', 1);
INSERT INTO `countries` VALUES (108, 'Laos', 'LA', 'LAO', 1);
INSERT INTO `countries` VALUES (109, 'Albani?', 'AL', 'ALB', 1);
INSERT INTO `countries` VALUES (110, 'Lesotho', 'LS', 'LSO', 1);
INSERT INTO `countries` VALUES (111, 'Letland', 'LV', 'LVA', 1);
INSERT INTO `countries` VALUES (112, 'Algerije', 'DZ', 'DZA', 1);
INSERT INTO `countries` VALUES (113, 'Libanon', 'LB', 'LBN', 1);
INSERT INTO `countries` VALUES (114, 'Liberia', 'LR', 'LBR', 1);
INSERT INTO `countries` VALUES (115, 'Libi?', 'LY', 'LBY', 1);
INSERT INTO `countries` VALUES (116, 'Liechtenstein', 'LI', 'LIE', 1);
INSERT INTO `countries` VALUES (117, 'Litouwen', 'LT', 'LTU', 1);
INSERT INTO `countries` VALUES (118, 'Luxemburg', 'LU', 'LUX', 1);
INSERT INTO `countries` VALUES (119, 'Macau', 'MO', 'MAC', 1);
INSERT INTO `countries` VALUES (120, 'Madagaskar', 'MG', 'MDG', 1);
INSERT INTO `countries` VALUES (121, 'Malawi', 'MW', 'MWI', 1);
INSERT INTO `countries` VALUES (122, 'Maldiven', 'MV', 'MDV', 1);
INSERT INTO `countries` VALUES (123, 'Maleisi?', 'MY', 'MYS', 1);
INSERT INTO `countries` VALUES (124, 'Mali', 'ML', 'MLI', 1);
INSERT INTO `countries` VALUES (125, 'Malta', 'MT', 'MLT', 1);
INSERT INTO `countries` VALUES (126, 'Marokko', 'MA', 'MAR', 1);
INSERT INTO `countries` VALUES (127, 'Marshalleilanden', 'MH', 'MHL', 1);
INSERT INTO `countries` VALUES (128, 'Martinique', 'MQ', 'MTQ', 1);
INSERT INTO `countries` VALUES (129, 'Mauritani?', 'MR', 'MRT', 1);
INSERT INTO `countries` VALUES (130, 'Mauritius', 'MU', 'MUS', 1);
INSERT INTO `countries` VALUES (131, 'Mayotte', 'YT', 'MYT', 1);
INSERT INTO `countries` VALUES (132, 'Amerikaans-Samoa', 'AS', 'ASM', 1);
INSERT INTO `countries` VALUES (133, 'Mexico', 'MX', 'MEX', 1);
INSERT INTO `countries` VALUES (134, 'Micronesia', 'FM', 'FSM', 1);
INSERT INTO `countries` VALUES (135, 'Moldavi?', 'MD', 'MDA', 1);
INSERT INTO `countries` VALUES (136, 'Monaco', 'MC', 'MCO', 1);
INSERT INTO `countries` VALUES (137, 'Mongoli?', 'MN', 'MNG', 1);
INSERT INTO `countries` VALUES (138, 'Montserrat', 'MS', 'MSR', 1);
INSERT INTO `countries` VALUES (139, 'Mozambique', 'MZ', 'MOZ', 1);
INSERT INTO `countries` VALUES (140, 'Myanmar', 'MM', 'MMR', 1);
INSERT INTO `countries` VALUES (141, 'Namibi?', 'NA', 'NAM', 1);
INSERT INTO `countries` VALUES (142, 'Nauru', 'NR', 'NRU', 1);
INSERT INTO `countries` VALUES (143, 'Andorra', 'AD', 'AND', 1);
INSERT INTO `countries` VALUES (144, 'Nederland', 'NL', 'NLD', 1);
INSERT INTO `countries` VALUES (145, 'Nederlandse Antillen', 'AN', 'ANT', 1);
INSERT INTO `countries` VALUES (146, 'Nepal', 'NP', 'NPL', 1);
INSERT INTO `countries` VALUES (147, 'Angola', 'AO', 'AGO', 1);
INSERT INTO `countries` VALUES (148, 'Anguilla', 'AI', 'AIA', 1);
INSERT INTO `countries` VALUES (149, 'Nicaragua', 'NI', 'NIC', 1);
INSERT INTO `countries` VALUES (150, 'Nieuw-Caledoni?', 'NC', 'NCL', 1);
INSERT INTO `countries` VALUES (151, 'Nieuw-Zeeland', 'NZ', 'NZL', 1);
INSERT INTO `countries` VALUES (152, 'Niger', 'NE', 'NER', 1);
INSERT INTO `countries` VALUES (153, 'Nigeria', 'NG', 'NGA', 1);
INSERT INTO `countries` VALUES (154, 'Niue', 'NU', 'NIU', 1);
INSERT INTO `countries` VALUES (155, 'Noordelijke Marianen', 'MP', 'MNP', 1);
INSERT INTO `countries` VALUES (156, 'Noord-Korea', 'KP', 'PRK', 1);
INSERT INTO `countries` VALUES (157, 'Noorwegen', 'NO', 'NOR', 1);
INSERT INTO `countries` VALUES (158, 'Norfolkeiland', 'NF', 'NFK', 1);
INSERT INTO `countries` VALUES (159, 'Antarctica', 'AQ', 'ATA', 1);
INSERT INTO `countries` VALUES (160, 'Antigua en Barbuda', 'AG', 'ATG', 1);
INSERT INTO `countries` VALUES (161, 'Oeganda', 'UG', 'UGA', 1);
INSERT INTO `countries` VALUES (162, 'Oekra?ne', 'UA', 'UKR', 1);
INSERT INTO `countries` VALUES (163, 'Oezbekistan', 'UZ', 'UZB', 1);
INSERT INTO `countries` VALUES (164, 'Oman', 'OM', 'OMN', 1);
INSERT INTO `countries` VALUES (165, 'Oostenrijk', 'AT', 'AUT', 5);
INSERT INTO `countries` VALUES (166, 'Oost-Timor', 'TP', 'TMP', 1);
INSERT INTO `countries` VALUES (167, 'Pakistan', 'PK', 'PAK', 1);
INSERT INTO `countries` VALUES (168, 'Palau', 'PW', 'PLW', 1);
INSERT INTO `countries` VALUES (169, 'Panama', 'PA', 'PAN', 1);
INSERT INTO `countries` VALUES (170, 'Papoea-Nieuw-Guinea', 'PG', 'PNG', 1);
INSERT INTO `countries` VALUES (171, 'Paraguay', 'PY', 'PRY', 1);
INSERT INTO `countries` VALUES (172, 'Peru', 'PE', 'PER', 1);
INSERT INTO `countries` VALUES (169, 'Pitcairneilanden', 'PN', 'PCN', 1);
INSERT INTO `countries` VALUES (173, 'Polen', 'PL', 'POL', 1);
INSERT INTO `countries` VALUES (174, 'Portugal', 'PT', 'PRT', 1);
INSERT INTO `countries` VALUES (175, 'Puerto Rico', 'PR', 'PRI', 1);
INSERT INTO `countries` VALUES (176, 'Qatar', 'QA', 'QAT', 1);
INSERT INTO `countries` VALUES (177, 'R?union', 'RE', 'REU', 1);
INSERT INTO `countries` VALUES (178, 'Roemeni?', 'RO', 'ROM', 1);
INSERT INTO `countries` VALUES (179, 'Rusland', 'RU', 'RUS', 1);
INSERT INTO `countries` VALUES (180, 'Rwanda', 'RW', 'RWA', 1);
INSERT INTO `countries` VALUES (181, 'Saint Kitts en Nevis', 'KN', 'KNA', 1);
INSERT INTO `countries` VALUES (182, 'Saint Lucia', 'LC', 'LCA', 1);
INSERT INTO `countries` VALUES (183, 'Saint Vincent en de Grenadines', 'VC', 'VCT', 1);
INSERT INTO `countries` VALUES (184, 'Saint-Pierre en Miquelon', 'PM', 'SPM', 1);
INSERT INTO `countries` VALUES (185, 'Salomonseilanden', 'SB', 'SLB', 1);
INSERT INTO `countries` VALUES (186, 'Samoa', 'WS', 'WSM', 1);
INSERT INTO `countries` VALUES (187, 'San Marino', 'SM', 'SMR', 1);
INSERT INTO `countries` VALUES (188, 'Sao Tom? en Principe', 'ST', 'STP', 1);
INSERT INTO `countries` VALUES (189, 'Saoedi-Arabi?', 'SA', 'SAU', 1);
INSERT INTO `countries` VALUES (190, 'Senegal', 'SN', 'SEN', 1);
INSERT INTO `countries` VALUES (191, 'Seychellen', 'SC', 'SYC', 1);
INSERT INTO `countries` VALUES (192, 'Sierra Leone', 'SL', 'SLE', 1);
INSERT INTO `countries` VALUES (193, 'Singapore', 'SG', 'SGP', 4);
INSERT INTO `countries` VALUES (194, 'Sint-Helena', 'SH', 'SHN', 1);
INSERT INTO `countries` VALUES (195, 'Sloveni?', 'SI', 'SVN', 1);
INSERT INTO `countries` VALUES (196, 'Slowakije', 'SK', 'SVK', 1);
INSERT INTO `countries` VALUES (197, 'Soedan', 'SD', 'SDN', 1);
INSERT INTO `countries` VALUES (198, 'Somali?', 'SO', 'SOM', 1);
INSERT INTO `countries` VALUES (199, 'Spanje', 'ES', 'ESP', 3);
INSERT INTO `countries` VALUES (200, 'Sri Lanka', 'LK', 'LKA', 1);
INSERT INTO `countries` VALUES (201, 'Suriname', 'SR', 'SUR', 1);
INSERT INTO `countries` VALUES (202, 'Svalbard en Jan Mayen', 'SJ', 'SJM', 1);
INSERT INTO `countries` VALUES (203, 'Swaziland', 'SZ', 'SWZ', 1);
INSERT INTO `countries` VALUES (204, 'Syri?', 'SY', 'SYR', 1);
INSERT INTO `countries` VALUES (205, 'Tadzjikistan', 'TJ', 'TJK', 1);
INSERT INTO `countries` VALUES (206, 'Taiwan', 'TW', 'TWN', 1);
INSERT INTO `countries` VALUES (207, 'Tanzania', 'TZ', 'TZA', 1);
INSERT INTO `countries` VALUES (208, 'Thailand', 'TH', 'THA', 1);
INSERT INTO `countries` VALUES (209, 'Togo', 'TG', 'TGO', 1);
INSERT INTO `countries` VALUES (210, 'Tokelau-eilanden', 'TK', 'TKL', 1);
INSERT INTO `countries` VALUES (211, 'Tonga', 'TO', 'TON', 1);
INSERT INTO `countries` VALUES (212, 'Trinidad en Tobago', 'TT', 'TTO', 1);
INSERT INTO `countries` VALUES (213, 'Tsjaad', 'TD', 'TCD', 1);
INSERT INTO `countries` VALUES (214, 'Tsjechi?', 'CZ', 'CZE', 1);
INSERT INTO `countries` VALUES (215, 'Tunesi?', 'TN', 'TUN', 1);
INSERT INTO `countries` VALUES (216, 'Turkije', 'TR', 'TUR', 1);
INSERT INTO `countries` VALUES (217, 'Turkmenistan', 'TM', 'TKM', 1);
INSERT INTO `countries` VALUES (218, 'Turks- en Caicoseilanden', 'TC', 'TCA', 1);
INSERT INTO `countries` VALUES (219, 'Tuvalu', 'TV', 'TUV', 1);
INSERT INTO `countries` VALUES (220, 'Uruguay', 'UY', 'URY', 1);
INSERT INTO `countries` VALUES (221, 'Vanuatu', 'VU', 'VUT', 1);
INSERT INTO `countries` VALUES (222, 'Vaticaanstad', 'VA', 'VAT', 1);
INSERT INTO `countries` VALUES (223, 'Venezuela', 'VE', 'VEN', 1);
INSERT INTO `countries` VALUES (224, 'Verenigd Koninkrijk', 'GB', 'GBR', 1);
INSERT INTO `countries` VALUES (225, 'Verenigde Arabische Emiraten', 'AE', 'ARE', 1);
INSERT INTO `countries` VALUES (226, 'Verenigde Staten', 'US', 'USA', 2);
INSERT INTO `countries` VALUES (227, 'Viet Nam', 'VN', 'VNM', 1);
INSERT INTO `countries` VALUES (228, 'Voormalige Joegoslavische Republiek Macedoni?', 'MK', 'MKD', 1);
INSERT INTO `countries` VALUES (229, 'Wallis en Futuna', 'WF', 'WLF', 1);
INSERT INTO `countries` VALUES (230, 'Westelijke Sahara', 'EH', 'ESH', 1);
INSERT INTO `countries` VALUES (231, 'Zaire', 'ZR', 'ZAR', 1);
INSERT INTO `countries` VALUES (232, 'Zambia', 'ZM', 'ZMB', 1);
INSERT INTO `countries` VALUES (233, 'Zimbabwe', 'ZW', 'ZWE', 1);
INSERT INTO `countries` VALUES (234, 'Zuid-Afrika', 'ZA', 'ZAF', 1);
INSERT INTO `countries` VALUES (235, 'Zuid-Georgi? en Zuidelijke Sandwicheilanden', 'GS', 'SGS', 1);
INSERT INTO `countries` VALUES (236, 'Zuid-Korea', 'KR', 'KOR', 1);
INSERT INTO `countries` VALUES (236, 'Zweden', 'SE', 'SWE', 1);
INSERT INTO `countries` VALUES (238, 'Zwitserland', 'CH', 'CHE', 1);

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. ~ Benjamin Franklin, 1759. տլ

Link to comment
Share on other sites

You didn't mention whether you know how to run a query in phpMyAdmin or not, but the above code will insert all those country names into your table. First, you'll need to empty (NOT drop) the countries table, then add these.

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. ~ Benjamin Franklin, 1759. տլ

Link to comment
Share on other sites

Just spotted little error, the line for Sweden "Zweden" should have 237 as id, not 236

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

Well, considering that when I did this I had been awake for almost 46 hours, I think I'll call that an acceptable margin for error. :lol:

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. ~ Benjamin Franklin, 1759. տլ

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...