Die Veranstaltungen
require("admin/db.class.php4");
$db = new db;
?>
$datumHeute = date("Y-m-d");
$wochentage = array("Sonntag","Montag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag");
$monate = array("","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember");
$sql = "SELECT * FROM kammerchor_termine WHERE datum >= '$datumHeute'";
$result = $db->sqlQuery($sql);
while($row = mysql_fetch_row($result)) {
$wochentag = $wochentage[date("w", strtotime($row[1]))];
$datumArr = explode("-", $row[1]);
$tag = $datumArr[2];
$monatID = $datumArr[1];
if($monatID < 10) {
$monatID = substr($monatID, 1, 1);
}
$monat = $monate[$monatID];
$jahr = $datumArr[0];
echo "$wochentag, $tag. $monat $jahr ";
echo "\n$row[2] ";
echo "\n ";
echo "\n$row[3] ";
}
?>
|