|
Über folgende Länder können Sie Informationen finden:
|
|
$Query = "SELECT DISTINCT countries.countryg, countries.countryid ";
$Query .= "From countries, regions, siteregion, sitecat ";
$Query .= "WHERE sitecat.catid='$catid' ";
$Query .= "AND countries.contid = '$contid' ";
$Query .= "AND sitecat.siteid = siteregion.siteid ";
$Query .= "AND siteregion.stateid = regions.stateid ";
$Query .= "AND regions.countryid = countries.countryid ";
$Query .= "ORDER BY countries.countryg";
if (!$dbresult = mysql_query ($Query))
{
print("couldn't execute query \n");
print("query was: $Query \n");
exit();
}
while($dbRow = mysql_fetch_object($dbresult))
{
$countryg = $dbRow->countryg;
$countryg = str_replace("ü","ü",$countryg);
$countryg = str_replace("ä","ä",$countryg);
$countryg = str_replace("ö","ö",$countryg);
print" | ";
print"";
print"countryid/$countryg\">\n";
print"countryid/$countryg\"> $dbRow->countryg\n";
print" | ";
print" ";
}
?>
|
switch($catid)
{
case "ws":
print("");
break;
case "rc":
print("");
break;
case "ic":
print("");
break;
case "ts":
print("");
break;
case "mb":
print("");
break;
case "wt":
print("");
break;
case "wc":
print("");
break;
default:
print("");
}
?> |