='".date('Y-m-d')."') AND schauspieler.aktiv=1 AND aktuelles.aktiv=1 order by schauspieler.name "; $result=@mysql_query($querystring,$MySqlHandle); while($row=mysql_fetch_row($result)){ if(!$row[3]||file_exists($_SERVER['DOCUMENT_ROOT']."/images/clienten/thumbs/".$row[3])!=true) $row[3]="default.gif"; echo <<< EOT \n"; echo " \n"; } ?>
 
News und Termine
 
\n
{$row[1]} {$row[2]}
EOT; $t0querystring="SELECT text FROM aktuelles where (termin='0000-00-00' OR termin IS NULL) AND sid=$row[0] AND aktiv='1'"; $t0result=@mysql_query($t0querystring,$MySqlHandle); while($row1=mysql_fetch_row($t0result)) { echo " \n"; } echo "
".$row1[0]."
\n"; $tnquerystring="SELECT * FROM aktuelles where termin>='".date('Y-m-d')."' AND sid=$row[0] AND aktiv='1' order by termin asc"; $tnresult=@mysql_query($tnquerystring,$MySqlHandle); while($row2=mysql_fetch_row($tnresult)) { if ($row2[8]) $regie="Regie: ".$row2[8]; echo " \n"; } echo "
".datum_de($row2[2]).", ".substr($row2[4],0,5)."-".substr($row2[5],0,5).", ".$row2[3]." ".$row2[6].", ".$row2[7].", ".$regie."
\n