Public feed #603872

Miscellany

public text v1 · immutable
Raw Edit
·published 2007-07-05 04:35 UTC
rendered paste body
/*
 * 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;
}