\n"; ?> http://www.uni-giessen.de/theater/de/events/programme Current programme of the Institute for Applied Theatre Studies de-de = DATE_FORMAT(NOW(),'%Y-%m-%d') " . "ORDER BY pa.datum"; $result = mysql_query($query) or die(mysql_error()); $number = mysql_num_rows($result); for($i=0; $i<$number; $i++) { $e = mysql_fetch_array($result); echo "\n" . "\n" . "Instangew.theaterwissenschaft@theater.uni-giessen.de (Institute for Applied Theatre Studies)\n" . "http://{$_SERVER["HTTP_HOST"]}{$base}/en/events/programme/{$e["id"]}\n" . "http://{$_SERVER["HTTP_HOST"]}{$base}/en/events/programme/{$e["id"]}\n" . "{$e["rubrik"]} by {$e["macher"]}
\n" . "Date: {$e["datum"]}"; if($e["uhrzeit"]) echo ", {$e["uhrzeit"]}"; if($e["spezial"]) echo " ({$e["spezial"]})"; echo "
\n" . "Location: {$e["ort"]}

\n]]>\n" . "{$e["zeit"]}\n" . "\n"; } mysql_free_result($result); echo "\n" . "\n";