1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23:

SELECT id,date FROM news;

while($news = mysql_fetch_array($q)){

if(date("d.m.Y",$news[1] == date("d.m.Y")){

 # datum ist gleich

 SELECT unique FROM news WHERE id = '".$news[0]."' ORDER BY date LIMIT 8;

 while(...){
  
  if($result[0] == true){
   
    # ausgabe

  }

 }

}

}