Mine

<BODY>

<?
$listele = mysql_query("SELECT okundu,id FROM privmsg WHERE `kime`='$verified_user'");
while ($kayit=mysql_fetch_array($listele)) {
$okundu=$kayit["okundu"];
$id=$kayit["id"];
if ($okundu != 0) {
$okunmayan++;
}
if ($okundu == 2) {
$notice++;
$sorgu = "UPDATE privmsg SET okundu = '1' WHERE id= '$id'";
mysql_query($sorgu);
}
}

if ($notice)
echo "<SCRIPT>alert('$notice okunmayan mesaj&#305;n&#305;z var. mesaj bölümünden kontrol edebilirsiniz.');</SCRIPT>";

if ($okunmayan)
$pms = " | <a title=\"$okunmayan okunmayan mesaj&#305;n&#305;z var\" href=sozluk.php?process=privmsg><img src=images/new.gif alt=\"$okunmayan okunmayan hede var\"><font size=1>($okunmayan)</font></a>";

?>
<table cellpadding=0 cellspacing=0 width="100%" height=300>
<tr><td class=vtabin width="100%">
<table></table>
  <table><tr><td>
  <fieldset><legend>bizlerden..</legend>
          <?
// $sorgu = "SELECT konu,aciklama,yazar,tarih,ay,gun,yil,saat FROM haberler ORDER BY `tarih` desc";
// $sorgu2 = "SELECT email,isim FROM user";
// $sorgulama2 = mysql_query($sorgu2);
$sorgulama = mysql_query($sorgu);
$sorgu = "SELECT konu,aciklama,yazar,tarih,ay,gun,yil,saat,email,isim FROM haberler LEFT JOIN user ON isim,email ORDER BY `tarih` desc";
if (mysql_num_rows($sorgulama)>0){
//kay&#305;tlar&#305; listele
while ($kayit=mysql_fetch_array($sorgulama)){
###################### var ##############################################
$konu=$kayit["konu"];
$aciklama=$kayit["aciklama"];
$yazar=$kayit["yazar"];
$tarih=$kayit["tarih"];
$ay=$kayit["ay"];
$gun=$kayit["gun"];
$yil=$kayit["yil"];
$saat=$kayit["saat"];
$isim=$kayit["isim"];
$email=$kayit["email"];
// }
// while ($kayit2=mysql_fetch_array($sorgulama2)){
// $maililetisim=$kayit2["email"];

$aciklama = preg_replace("'\(bkz: (.*)\)'Ui","(bkz: <a href=\"sozluk.php?process=word&q=\\1\">\\1</a>)",$aciklama);
$aciklama = preg_replace("'\(gbkz: (.*)\)'Ui","<a href=\"sozluk.php?process=word&q=\\1\">\\1</a>",$aciklama);
$aciklama = preg_replace("'\(u: (.*)\)'Ui","<a href=\"sozluk.php?process=word&q=\\1\" title=\"\\1\">*</a>",$aciklama);
$aciklama = preg_replace( "`((http)+(s)?:(//)|(www\.))((\w|\.|\-|_)+)(/)?(\S+)?`i", "(url: <a target=_blank href=\"http\\3://\\5\\6\\8\\9\" title=\"\\0\">\\0</a>)", $aciklama);
$mesaj = preg_replace("'\#([0-9]{1,9})'","<a href=sozluk.php?process=eid&eid=\\1>#\\1</a>",$mesaj);

echo "
<a class=highligth>$konu
      [$gun/$ay/$yil $saat]</a><BR>
      <font size=1>$aciklama</font>
      <BR>
      <strong><a href='sozluk.php?process=word&q=$yazar'>$yazar</a><font size=1> ($isim - $email) </font> </strong>
      <HR SIZE=1>
      ";
}
}
?>

      <div class=msg style="text-align:center">(<a href="#">böyle oldu i&#351;te</a>)</div></fieldset>
       </td></tr></table></td><td valign=top><table border=0 cellspacing=0 height="100%"><tr><td class=vtabsel>olay</td></tr><tr><td class=vtab><div><a href="sozluk.php?process=cp">ayarlar</a></div></td></tr><tr><td class=vtab><div><a href="sozluk.php?process=gorunum">gorunum</a></div></td></tr><tr><td class=vtab height="100%">&nbsp;</td></tr></table></td></tr></table>

<?
/*
?>


</TR>
  <TR>
    <TD colSpan=3>
    <fieldset><legend>desteklediklerimiz<legend>
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
</TABLE>

</BODY>
<?
*/
?>
</HTML>