| Main Menu | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Hier findet ihr die wichtigsten Festivals des Jahres mit einem überwiegend \"schwarzen\" Line-Up.
"; echo "| $date -"; $date = date("d.m.Y", $date_to); echo " $date | "; $anfrage3="SELECT festival_name_seo from content_seo_festivals where festival_name=\"$name\""; $result3=mysql_db_query("labellos",$anfrage3); $line=mysql_fetch_row($result3); $link="http://".$line[0].".labellos.de"; echo "$name | "; echo "$ort ($state) | "; echo "
Vergangene Festivals"; else echo "
Aktuelle Festivals"; } else { echo "
$name
"; echo "| $date_from - $date_to | "; echo "
| $city, $plz $state | "; echo "
| $description | "; echo "
| $link | "; echo "
| [Zum Merkzettel hinzufügen] | "; echo "
Künstler:
";
$anfrage="select more_bands from content_festivals where id=$id";
$result=mysql_db_query("labellos",$anfrage);
$row=mysql_fetch_row($result);
$bands=explode(";",$row[0]);
$band_array=array();
foreach ($bands as $band)
{
array_push($band_array,$band);
}
$anfrage = "select b.gigcal_bands_id,b.bandname from content_festival_id a, jos_gigcal_bands b where a.festival_id=$id and b.gigcal_bands_id=a.band_id order by b.bandname";
$result=mysql_db_query("labellos",$anfrage);
while ($row=mysql_fetch_array($result))
{
$id= $row[0];
$name = $row[1];
array_push($band_array,$name);
}
natcasesort($band_array);
$no_db=false;
foreach ($band_array as $name)
{
if ($name=="")
{
}
else
{
$anfrage= "select * from content_seo_bands where bandname=\"$name\"";
$result2 = mysql_query($anfrage);
if (mysql_num_rows($result2)>0)
{
$row2=mysql_fetch_row($result2);
$bandlink="http://".$row2[2].".labellos.de";
echo "$name
";
}
else
{
$no_db=true;
echo "".$name."
";
}
}
}
echo "
Grau eingefärbte Bands/Künstler sind nicht in der LabelLos.de-Datenbank
"; } for ($i=0;$i<10;$i++) { $num=rand(0,count($band_array)); $keywords.=$band_array[$num].","; } $keywords = substr($keywords, 0, -1); $mainframe->prependMetaTag("keywords", $keywords ); } ?>