$tarih = date("d-m-Y");
echo $tarih;
echo "<br>";
$ikigunonce = time() - (2080 * 3600);
//$tarih = $ikigunonce;
$sil = mysql_query("delete from tablo where tarih<'$ikigunonce'");
echo "3 ay onceki veriler silindi.";
?>
<font face="verdana" size="2" color="Red">Referans Listesi</font><br>
<table width="800" border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<td align="center"><b>id<b></td>
<td align="center"><b>Baslık<b></td>
<td align="center"><b>Tarih<b></td>
<td align="center"><b>resim<b></td>
</tr>
<?
$oku = mysql_query("SELECT * FROM tablo ORDER BY tarih DESC");
//$oku=mysql_query("select distinct ref from referer ORDER BY tarih DESC");
while ($okunan = mysql_fetch_array($oku)){
?>
<tr>
<td align="center" style="font-size: xx-small;"> <?=$okunan['id']?> </td>
<td width="170" height="11" align="center" style="font-size: x-small;"><?=$okunan['baslik']?> </td>
<td align="center" style="font-size: xx-small;"><?=$okunan['tarih']?> </td>
<td align="center" style="font-size: xx-small;"><?=$okunan['resim']?> </td>
</tr>
<?php
}
?> </table>
</center></body></html>