<?
      include("file.php");
     $db_connect = mysql_pconnect ("$db_host", $db_user, $db_passwort);

     $sql_befehl = "select * from $dates order by realdate asc ;";
     $ergebnis = mysql_db_query ( $db_name, $sql_befehl, $db_connect );

     $my_date = date(Ymd);

?>
<?      
        $anzahl = mysql_num_rows ( $ergebnis ); 
        for ( $i = 1; $i <= $anzahl ; $i++ ) 
             { 
             $datensatz = mysql_fetch_array 
            ($ergebnis); 
        
            if ($datensatz[8] > $my_date)
                    {
        echo ("
   <tr> 
    <td width=65 valign=top>$datensatz[1]</td>
    <td width=80 valign=top>$datensatz[4]</td>
    <td width=120 valign=top>$datensatz[3]</td>
      <td width=200 valign=top><a href=\"$datensatz[7]\" target=\"_blank\" class=\"orange\"><font class=link_1>$datensatz[6]</font></a></td>
  </tr>
"); 
                    }
                else
                    {
        echo ("
   <tr> 
    <td width=65 valign=top>$datensatz[1]</td>
    <td width=80 valign=top>$datensatz[4]</td>
    <td width=120 valign=top>$datensatz[3]</td>
      <td width=200 valign=top><a href=\"$datensatz[7]\" target=\"_blank\" class=\"orange\"><font class=link_1>$datensatz[6]</font></a></td>
  </tr>
"); 
        
                    }
        
}     
?>