MySQL - Query Statement gesucht

[Mike©]

Moin Vinzenz,

ich habe es so gelöst:

  
  
$query = "select max(entry_timestamp) as latest from berichte WHERE newsletter='N' group by mannschaft";  
$result = mysql_query($query, $db_pointer);  
  
while ($liste=mysql_fetch_array($result) )  
      {  
 $latest=$liste['latest'];  
  
 $query1="select header from berichte WHERE entry_timestamp=$latest";  
 $result1 = mysql_query($query1, $db_pointer);  
 $liste1=mysql_fetch_array($result1);  
  
 $Header=$liste1['header'];  
  
 echo '  
 '.$Header.'  
 <br>';  
      }  

regds
Mike©