header('content-type: text/html; charset=utf-8');
$DBHost = "localhost:3306";
$DBUser = "schurl" ;
$DBPasswd = "aNQrt24x" ;
$DBName = "WebhostingAustria2_zuenftig" ;
mysql_connect ( $DBHost , $DBUser , $DBPasswd) or die("Konnte keine Verbindung herstellen");
mysql_select_db ($DBName ) ;
$zeit=date("y-m-d");
?>
$res = mysql_query("select datum, veranstaltung, ort, art from termine where datum BETWEEN '" . $zeit . "' AND '2100-12-31' order by datum asc;" );
echo mysql_error ("Geht Nicht") ;
$row = mysql_fetch_array ($res);
echo "
Nächster Auftritt: ";
echo htmlentities($row['datum']) . ", ";
echo htmlentities($row['veranstaltung']) . ", ";
echo htmlentities($row['ort']);
echo "
";
?>