Merhaba

refer'lari vt ye kayıt ediyorum.. VT şişmesin diye, 2 gün önceki verileri silmek istiyorum.. Hata yok, fakat 2 gün önceki veriler silinmiyor. Yardımcı olursanız memnun olurum..

<?
/*tablo yapısı
CREATE TABLE IF NOT EXISTS `referer` (
  `id` smallint(6) NOT NULL auto_increment,
  `time` time default NULL,
  `ref` varchar(155) NOT NULL default '',
  `uri` varchar(50) NOT NULL default '',
  `ipi` text NOT NULL,
  `tarih` varchar(10) NOT NULL default '',
  `saat` varchar(8) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5385 ;
*/
$tarih = date("d-m-Y");
echo $tarih;
echo "<br>";
$ikigunonce = time() - (48 * 3600);
//$tarih = $ikigunonce;
$sil = mysql_query("delete from referer where time<'$ikigunonce'");  
echo "2 gun onceki  veriler silindi.";
?>
&nbsp;&nbsp;&nbsp;<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>Ref<b></td> 
    <td align="CENTER"><b>Tarih<b></td>  
    <td align="CENTER"><b>Saat<b></td>  
    <td align="CENTER"><b>iP<b></td>
 <!--<td align="CENTER"><b>Agent<b></td> --> 
    <td align="CENTER"><b>Uri<b></td>  
  </tr> 
<? 
$oku = mysql_query("SELECT * FROM referer 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;">&nbsp;<?=$okunan['id']?>&nbsp;</td>
    <td width="170" height="11" align="CENTER" style="font-size: x-small;"><?=$okunan['ref']?>&nbsp;</td>  
    <td align="CENTER" style="font-size: xx-small;"><?=$okunan['tarih']?>&nbsp;</td> 
	<td align="CENTER" style="font-size: xx-small;"><?=$okunan['saat']?>&nbsp;</td>
	<td align="CENTER" style="font-size: xx-small;"><?=$okunan['ipi']?>&nbsp;</td> 
<!--<td align="CENTER" style="font-size: xx-small;"><?=$okunan['agent']?>&nbsp;</td> -->
	<td align="CENTER" style="font-size: xx-small;"><?=$okunan['uri']?>&nbsp;</td> 
 </tr> 
<?php 
} 
?> </table>
</center></body></html>