session_start(); include 'config.php'; include 'classes/cSystem.php'; include 'classes/cMySQL.php'; include 'classes/cTemplate.php'; $mysql = new cMySQL; $mysql -> connect($db_host,$db_user,$db_pass); $mysql -> selectDB($db_name); IF(!isset($_GET["monat"])) $_GET["monat"] = date("m"); IF(!isset($_GET["jahr"])) $_GET["jahr"] = date("Y"); ob_start(); ## # Ausgabe der Messen ## IF(checkdate($_GET["monat"],1,$_GET["jahr"]) && $_REQUEST["setFilter"]==1){ $t1 = mktime(0,0,0,$_GET["monat"],1,$_GET["jahr"]); $t2 = mktime(23,59,59,$_GET["monat"],date("t",mktime(0,0,0,$_GET["monat"],1,$_GET["jahr"])),$_GET["jahr"]); $mysql -> query("SELECT id,messe,ort,beschreibung,datum_von,datum_bis FROM messe_termine WHERE (datum_von>'$t1' && datum_von<'$t2') || (datum_bis>'$t1' && datum_bis<'$t2') ORDER BY datum_von DESC,datum_bis DESC"); }ELSE $mysql -> query("SELECT id,messe,ort,beschreibung,datum_von,datum_bis FROM messe_termine ORDER BY datum_von ASC,datum_bis ASC"); ?>
| Aktuelle Messetermine: | |||
| ID | Datum | Name | Ort |
| ".(++$number).". | ".date("d.m.",$mysql->get('datum_von'))."-".date("d.m. Y",$mysql->get('datum_bis'))." | ".stripslashes($mysql->get('messe'))." | ".stripslashes($mysql->get('ort'))." |
| ".stripslashes(nl2br($mysql->get('beschreibung')))." | |||
|   | |||
| Keine Einträge | |||