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.";
?>
<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;"> <?=$okunan['id']?> </td>
<td width="170" height="11" align="CENTER" style="font-size: x-small;"><?=$okunan['ref']?> </td>
<td align="CENTER" style="font-size: xx-small;"><?=$okunan['tarih']?> </td>
<td align="CENTER" style="font-size: xx-small;"><?=$okunan['saat']?> </td>
<td align="CENTER" style="font-size: xx-small;"><?=$okunan['ipi']?> </td>
<!--<td align="CENTER" style="font-size: xx-small;"><?=$okunan['agent']?> </td> -->
<td align="CENTER" style="font-size: xx-small;"><?=$okunan['uri']?> </td>
</tr>
<?php
}
?> </table>
</center></body></html>
. Localde dene