<?

$haber_al = mysql_query("SELECT * FROM ero ORDER BY tarih DESC");
$sayi = mysql_num_rows($haber_al);
$limit="50";
$sayfasayisi=ceil($sayi/$limit);
$sayfano = !empty($_GET["sayfano"]) ? intval($_GET["sayfano"]) : 1;
$b=$sayfano-1;
$a=$b*$limit;
$haber_al2 = mysql_query("SELECT * FROM ero ORDER BY tarih DESC LIMIT $a,$limit");
echo "<br>";
echo '<a href="admin.php?yonetim=yaziekle">Yazı Ekle</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
echo "Toplam Yazi : <b>$sayi</b>";
if ($sayi > 0){

echo '<table align="center" width="650"><tr>';
echo '<td width="5%"><b>No</b></td>';
echo '<td width="40%"><b>İçeril</b></td>';

echo '<td width="12%"><b>Ekleyen</b></td>';
echo '<td width="13%"><b>Tarih</b></td>';
echo '<td width="10%"></td>';
echo '<td width="5%"></td>';
echo '</tr>';
$ii=0+$a;
$i=1;
while ( $haberler = mysql_fetch_array($haber_al2) ){
$ii++;
$tarih = $haberler["tarih"];
$tarih = date("d/m/Y",$tarih);

echo '<tr><td>'.$ii.'</td>';
echo '<td>'.$haberler["baslik"].'</td>';

echo '<td>'.$haberler["ekleyen"].'</td>';
echo '<td>'.$tarih.'</td>';
echo '<td><a href="admin.php?sayfa=duzenleyazi&id='.$haberler["id"].'">Düzelt</a></td>';
echo '<td><a href="admin.php?sayfa=silyazi&id='.$haberler["id"].'">SİL</a></td></tr>';
if($haberler['onay']=="h") { echo '<td><a alt="Sil" title="Sil" href="admin.php?sayfa=onaylayazi&id='.$haberler["id"].'">Onayla</a></td></tr>'; }

$i++;
}

echo '</table>Sayfa : ';
for($i=1;$i<=$sayfasayisi;$i++){echo "<a href=admin.php?yonetim=yazilar&sayfano=".$i.">".$i ."</a> ";}

} else {

echo '<b>Şuan yazi Eklenmemiş!</b>';

}
echo "<br><br>";
?>