Ho fatto così:
$result = mysql_query("SELECT COUNT(*) as tot FROM PI_REFERER");
while ($row=mysql_fetch_array($result)) {
if($row["tot"] > 5) {
$tot = $row['tot'] - 5;
$result = mysql_query("DELETE FROM PI_REFERER ORDER BY DATA ASC LIMIT $tot");
}
}
e cancella come si deve, mandandomi però
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhost/portaleitalia/myasg/stats.php on line 7
perché?![]()