$db = mysql_connect("mysql3.unoeuro.com", "radiomix_dk", "buller") or die("Could not connect.");
if(!$db)
die("no db");
if(!mysql_select_db("radiomix_dk_db",$db))
die("No database selected.");
function flag($country,$width,$height)
{
$folder = "http://www.radiomix.dk/gfx/flags";
if($country == "dk"){ echo "
"; }
elseif($country == "de"){ echo "
"; }
elseif($country == "no"){ echo "
"; }
elseif($country == "se"){ echo "
"; }
elseif($country == "uk"){ echo "
"; }
elseif($country == "us"){ echo "
"; }
elseif($country == "fr"){ echo "
"; }
elseif($country == "is"){ echo "
"; }
elseif($country == "fo"){ echo "
"; }
elseif($country == "fi"){ echo "
"; }
elseif($country == "ww"){ echo "
"; }
else { echo "
"; }
}
function countryname($country)
{
$folder = "http://www.radiomix.dk/gfx/flags";
if($country == "dk"){ $countryname = "Danmark"; }
elseif($country == "de"){ $countryname = "Tyskland"; }
elseif($country == "no"){ $countryname = "Norge"; }
elseif($country == "se"){ $countryname = "Sverige"; }
elseif($country == "uk"){ $countryname = "England"; }
elseif($country == "us"){ $countryname = "USA"; }
elseif($country == "fr"){ $countryname = "Frankrig"; }
elseif($country == "is"){ $countryname = "Island"; }
elseif($country == "fo"){ $countryname = "Færøerne"; }
elseif($country == "fi"){ $countryname = "Finland"; }
elseif($country == "ww"){ $countryname = "International"; }
else { $countryname = "Ukendt"; }
return $countryname;
}
function catname($id)
{
$catSQL = mysql_query("SELECT * FROM categories WHERE ID='$id' LIMIT 1");
$catROW = mysql_fetch_array($catSQL);
return $catROW['name'];
}
function ratingstars($rating,$size)
{
$newrating = round($rating);
$onSrc = "http://www.radiomix.dk/gfx/rating/star.gif";
$offSrc = "http://www.radiomix.dk/gfx/rating/star2.gif";
if($newrating == "1") return "";
elseif($newrating == "2") return "
";
elseif($newrating == "3") return "
";
elseif($newrating == "4") return "
";
elseif($newrating == "5") return "
";
else return " ";
}
?>
|
Genrer
$catsSQL = mysql_query("SELECT * FROM categories ORDER BY name ASC");
while($catsROW = mysql_fetch_array($catsSQL))
{
?>
» =$catsROW['name'];?>} ?> |
if($_GET[id] == "") echo "Alle genrer"; else echo $catROW['name']; ?>
|