$verbindung = @mysql_connect("$sqlhost","$sqluser","$sqlpass");
if (!$verbindung) {
		echo "Keine Verbindung möglich!\n";
		exit;
	}
$abfrage = "SELECT idnr,tag,date_format(datum, '%d.%m.%Y'),time,wo,anlass,checkbox from $sqltable where checkbox='JA' datum >= NOW() And datum <= Date_ADD(Now(), interval 14 day) order by datum desc";  
$erg = mysql_db_query($sqldb,$abfrage,$verbindung);
while (list($idnr,$tag,$datum,$time,$wo,$anlass,$checkbox) = mysql_fetch_row($erg)) {
$wo = nl2br($wo);

echo "
<tr>
<td width=\"30\" valign=baseline bgcolor=$tbbg1 >
<font face=$face1 size=$size2 color=$tbtext1 >
<center>
$tag</a> 
</center>
</td>
<td width=\"90\" valign=baseline bgcolor=$tbbg1 >
<font face=$face1 size=$size1 color=$tbtext1 >
<center>
$datum</a> 
</center>
</td>
<td width=\"40\" valign=baseline bgcolor=$tbbg1 >
<font face=$face1 size=$size1 color=$tbtext1 >
<center>
$time</a> 
</center>
</td>
<td width=\"300\" valign=baseline bgcolor=$tbbg1 >
<font face=$face1 size=$size2 color=$tbtext1 >
<center>
$wo</a> 
</center>
</td>
<td width=\"400\" valign=baseline bgcolor=$tbbg1 >
<font face=$face1 size=$size2 color=$tbtext1 >
<center>
$anlass</a> 
</center>
</td>


</tr>
"; }
mysql_close($verbindung);
?>
</table>
<form action=add.php method=POST target="_blank"><font face="Arial, Helvetica, sans-serif"><center> 
  <hr align="center" width=150% noshade <? include("config.php"); echo "color=$hr"; ?> >
  <div align="right">Alle Termine ansehen </div>
</form>
<table width="100%" border="0">
  <tr>
    <td width="49%"> <p align="center">

        Wir freuen uns sie bei unseren n&auml;chsten Auftritten begr&uuml;&szlig;en 
        zu d&uuml;rfen.</p>
      <p align="center">Ihre Blaskapelle Vindemia

      </p></td>
    <td width="51%">
<table width="53%" height="78" border="0" align="center">
        <tr>
          <td width="34%" height="72">


Auftritte:</p>
            

</p>
            </td>
          <td width="66%"><div align="center">

              2004

              2003 </div></td>
        </tr>
      </table></td>
  </tr>
</table>


</p>
</body>
</html>

$abfrage = "SELECT idnr,tag,date_format(datum, '%d.%m.%Y'),time,wo,anlass,checkbox from $sqltable where datum >= NOW() And datum <= Date_ADD(Now(), interval 14 day)";

$abfrage = "SELECT idnr,tag,date_format(datum, '%d.%m.%Y'),time,wo,anlass,checkbox from $sqltable where checkbox='JA' AND (datum >= NOW() And datum <= Date_ADD(Now(), interval 14 day)) order by datum desc";