";
$content .= "Africa| ".doGetCountrylistForRegion("cn_short_en", "(2, 14, 17, 15, 18, 11)")." |  |
|
";
$content .= "Amériques/Caraïbes | ".doGetCountrylistForRegion("cn_short_en", "(19, 29, 13, 21, 5)")." |  |
|
";
$content .= "Asie / Pacifique | ".doGetCountrylistForRegion("cn_short_en", "(142, 53, 143, 30, 54, 57, 9, 61, 34, 35)")." |  |
|
";
$content .= "Europe| ".doGetCountrylistForRegion("cn_short_en", "(151, 150, 154, 39, 155)")." |  |
|
";
$content .= "Moyen-Orient| ".doGetCountrylistForRegionSpecial("cn_short_en", "(145)")." |  |
|
";
}
echo $content;
function getRegionName($column, $incomingID){
$renderedList = null;
$whereCond=" WHERE tr_iso_nr =".$incomingID;
$query = "SELECT ".$column." FROM static_territories ".$whereCond;
$list = mysql(TYPO3_db, $query);
while($resRow = mysql_fetch_assoc($list)) {
$renderedList .= $resRow[$column];
}
return $renderedList;
}
function doGetRegionlist($column){
$renderedList = null;
$selected = null;
$whereCond=" WHERE tr_iso_nr in (select cn_parent_tr_iso_nr from static_countries where cn_short_en in (select country from fe_users where deleted=0))";
$query = "SELECT uid,tr_iso_nr, ".$column." FROM static_territories ".$whereCond." order by ".$column;
$list = mysql(TYPO3_db, $query);
while($resRow = mysql_fetch_assoc($list)) {
$renderedList .= "