i just noticed right now that it is counting every single record in the antiabuse table, right now there are 780 records there so the script works when i go > 800 but not when I go > 700
example of my time stamp = 2011-05-18 18:31:25
here is the script i have =
Code:
//antiabuse - makes sure no more than 400 emails are sent out in one hour
mysql_query("INSERT INTO antiabuse (emailsent)
VALUES ('1')");
$result = mysql_query("select count(*) from antiabuse where 'time' < now() - 3600");
$row = mysql_fetch_row($result);
$count = $row[0];
if ($count > 400) {
die('');
}
// end antiabuse for hostgator