// require('typo3conf/localconf.php');
require('/home/marodayh/www.marcant-music.com/typo3conf/localconf.php');
$connect = mysql_connect($typo_db_host, $typo_db_username, $typo_db_password);
$heute = date("Y-m-d");
if($connect)
{
$sql = "SELECT * FROM event_info WHERE ((date>='$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";
}
}
?>