/* * Create default properties for ctry objects */ xarModSetVar('xpgeo', 'updatectry', 'ISO 3166-1:2006-09-26 Newsletter V-12 Serbia, Montenegro'); $query = array(); $ctry = array( "'AD','AND','020','Andorra','Andorra (ca) 7 parishes (en) / paroisse (fr) / parròquia (ca) List sources: IGN 1990; FIPS 10-4 Code source: ISO/TC 46/WG 2 Secretariat (*)'", "'AE','ARE','784','United Arab Emirates','7 emirates imārah (ar) List source: PCGN 1996; FIPS 10-4; IGN 1986 Code source: ISO/TC 46/WG 2 Secretariat (*) Romanization system: BGN/PCGN 1956'", ... ); foreach ($ctry as $ctry1) { $query = "INSERT INTO $xpgeoctrytable ( alpha2, alpha3, num3, ctryname, description ) VALUES ($ctry1)"; $result = $dbconn->Execute($query); if (!isset($result)) return; }