Termine

='$heute')AND(status=1)) ORDER BY date"; $ergebnis = mysql_db_query($typo_db, $sql, $connect); if($ergebnis) { $zeile = mysql_fetch_row($ergebnis); $eid = $zeile[0]; $lid = $zeile[1]; $date = $zeile[2]; $time = $zeile[3]; $teaser = $zeile[4]; $text = $zeile[5]; // $status = $zeile[6]; $sql2 = "SELECT * FROM event_location WHERE lid='$lid'"; $ergebnis2 = mysql_db_query($typo_db, $sql2, $connect); $zeile2 = mysql_fetch_row($ergebnis2); // $lid = $zeile2[0]; $city = $zeile2[1]; $location = $zeile2[2]; $address = $zeile2[3]; $web = $zeile2[4]; $lon = $zeile2[5]; $lat = $zeile2[6]; // $status = $zeile2[7]; $t = substr($date,8,2); $m = substr($date,5,2); $j = substr($date,2,2); $datum = $t.".".$m.".".$j; if($date==$heute) $datum = "heute"; echo "\n"; } } ?>