<?php
#heute

$Tag = date("d");
$Monat = date("m");
$Jahr = date("Y");
$heute=$Jahr.$Monat.$Tag;

include ('php_termine/pwdabfrage.php');

$dbh=mysql_connect($dbserver,$dbuser,$dbpasswd);
mysql_select_db($dbname,$dbh);

$sql="SELECT * FROM $dbtabelle WHERE $feld8 >= $heute and $feld9='Ja' order by $feld8 asc LIMIT 0 , 1";

$result=mysql_query($sql,$dbh);

?>

<?php

echo " <body bgcolor='$farbe4'><p align=\"center\"><font face=\"monotype corsiva\" size=\"4\" color=\"$farbe1\"><b>Nächster Termin</b></p></font>
";
?>

<?php

echo "<div align=\"left\"><table border=\"0\" width=\"180px\" style=\"border: 0px solid #872525\" cellspacing=\"0\" cellpadding=\"0\"id=\"naechster_termin\">";

while($row=mysql_fetch_row($result))
{

echo "

<tr><td colspan='2' class='Datum' ><font face=\"arial\"size=\"2\" color=\"#000000\" ><b> ",$row[4],", ",$row[1],".",$row[2],".",$row[3],"</b></td></tr>
<tr bgcolor='#f8f9fa'><td width='50px'>Zeit: </td><td ><font face=\"arial\"size=\"2\" color=\"#000000\">",$row[5]," Uhr</td></tr>
<tr><td width='50px'>Termin:</td><td ><font face=\"arial\"size=\"2\" color=\"#000000\"> ",$row[6]," </td></tr>
<tr bgcolor='#f8f9fa'><td width='50px'>Ort:</td><td ><font face=\"arial\"size=\"2\" color=\"#000000\">",$row[7]," </td></tr>

";

}

echo " </table> </div> ";

<?php
mysql_close($dbh);
?>