|
|
|
|
WriteSelectboxFixedVals("art",$art,array("alle" => "Alle Termine","kind" => "Kinder", "erwachsene" => "Erwachsene","workshop" => "Workshops"),"","onChange=document.theform.submit();"); ?>
|
|


|
|
| Legende: |
| Kinder |
Erwachsene |
Workshops |
$sql = "select WEEKDAY(datum) as wochentag,bemerkung,datum,YEAR(datum) as jahr,MONTH(datum) as monat,DAYOFMONTH(datum) as tag,zeit,stueck.name,stueck.art, auftritt.location,loctext,plz,ort,strasse,telefon,link from ";
$sql .= "auftritt,stueck where auftritt.stueck=stueck.id ";
if($art<>"alle"&&$art<>-1)
$sql .= " and art='$art'";
$sql .= "group by jahr,monat,datum,stueck.art,zeit,stueck.name";
$result = DB_Query($sql);
$current = "";
if(DB_Numrows($result)==0)
{
?>
| keine einträge gefunden |
}
else
{
while($row=DB_Fetch_Array($result))
{
if($row["monat"]!=$current)
{
$current = $row["monat"];
$bgclass = "hilite";
?>
|
| =GetMonthName($row["monat"])?> =$row["jahr"]?> |
|
|
| Wann? |
Was? |
Beschreibung |
Wo? |
}
?>
">
if(Date("Y-m-d")==($row["jahr"] . "-" . $row["monat"] . "-" . $row["tag"]))
echo "";
?>
=GetWeekdayName($row["wochentag"]) . ", " . $row["tag"] . "." . $row["monat"] . "., " . toGermanTime($row["zeit"])?> |
=$row["name"]?> |
=$row["bemerkung"]?> |
if(!is_null($row["location"]))
{
$sql = "select loctext,plz,ort,strasse,telefon,link from location where id=" . $row["location"];
$result2 = DB_Query($sql);
$content_row = DB_Fetch_Array($result2);
}
else
$content_row = $row;
echo $content_row["loctext"] . " " . $content_row["strasse"] . " " . $content_row["plz"] . " " . $content_row["ort"] . " ";
echo $content_row["telefon"] . " " . (!is_null($content_row["link"])&&$content_row["link"]<>""?"http://" . $content_row["link"]:"") . " ";
?>
|
}
if($bgclass=="hilite")
$bgclass="nonhilite";
else
$bglcass="hilite";
}
?>
|