jerry1970 Posted July 12, 2004 Share Posted July 12, 2004 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 More sharing options...
Mary B. Posted July 14, 2004 Share Posted July 14, 2004 How easy is this? ;) http://www.foreignword.com/countries/Dutch.htm 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 More sharing options...
jerry1970 Posted July 14, 2004 Author Share Posted July 14, 2004 Ha, that's real easy, but I was asking for an easy way to get those into the database... ;-) Thanks anyway, Jerry Link to comment Share on other sites More sharing options...
Mary B. Posted July 15, 2004 Share Posted July 15, 2004 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 More sharing options...
Mary B. Posted July 16, 2004 Share Posted July 16, 2004 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 More sharing options...
Mary B. Posted July 16, 2004 Share Posted July 16, 2004 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 More sharing options...
jerry1970 Posted July 17, 2004 Author Share Posted July 17, 2004 Mary, many thanks for this! Yes, this is indeed what I want. And yes, I do know how to run MySQL queries. Many thanks!!! Jerry Link to comment Share on other sites More sharing options...
♥bruyndoncx Posted July 17, 2004 Share Posted July 17, 2004 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 More sharing options...
Mary B. Posted July 17, 2004 Share Posted July 17, 2004 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.