Mine

<?
header("Content-Type: text/xml; charset=ISO-8859-9"); 
@mysql_connect("localhost","root","root");
@mysql_select_db("blog");
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
$gunluksql = mysql_query("SELECT * FROM gunluk ORDER BY tarih DESC");
//$gunlukrow = mysql_fetch_assoc($gunluksql);
//$yorumsql = mysql_query("SELECT * FROM youmlar where gunlukid='" . mysql_result($gunluksql,0,"id") . "'");
//$yorumsayisi = count($yorumsql); 
//if ( $yorumsayisi == 0) {
	//$yorumyazi = "<b><i>Yorum Yok..<b/></i>";
//}
//else {
//	$yorumyazi = "<b>Yorumlar (" . $yorumsayisi . ")</b>";
//}
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?while ($gunlukrow = mysql_fetch_assoc($gunluksql)) {?>
  <tr>
    <td><b><?echo$gunlukrow['baslik'];?> [ <?echo $gunlukrow['tarih'];?> ]</b> </td>
  </tr>
  <tr>
    <td><?echo $gunlukrow['icerik'];?></td>
  </tr>
  <tr>
    <td height="20"><img src="resimler/yorumlar.gif" width="14" height="13"><?echo $yorumsayisi;?></td>
  </tr>
</table>
<?}?>