<?
    
   $cek=mysql_query("select * from olaylar where durumu='1' order by olay_id desc");
   while($veri= mysql_fetch_assoc($cek)) {


    
   $acek=mysql_query("select * from yazi where yazi_id='".$veri['yazi_id']."'");
   $yazi= mysql_fetch_assoc($acek); 
 
?>
<h3><b>» Yeni</b> Olaylar</h3>
<table class="table" border="0" cellspacing="1" cellpadding="1">
   
  <tr class="cd">
    <td><small><? echo $veri['olay_id']; ?></small></td>
    <td><? echo $yazi[yaziadi]; ?></td>
    <td class="kirmizi"><? echo $veri['baslik']; ?></td>
    <td class="kr-bg"><b></b><a href="incele.php?olay_id=<? echo $veri['olay_id'];?>">Görüntüle</a></td>
  </tr>
</table>
<?php  }?>