The code works, but I am wondering if there is a more efficient way of doing this. I am just posting various statistics on how many people have signed up in the last 24 hours, 48 hours and total...
$sigcount24 = mysql_query("SELECT COUNT(signature_id) as ncount FROM signatures WHERE UNIX_TIMESTAMP(DATE) >= UNIX_TIMESTAMP() - 86400");
$sigrow = mysql_fetch_array($sigcount24);
print "<p>".$sigrow["ncount"]." signatures within 24 hours.</p>";
$sigcount48 = mysql_query("SELECT COUNT(signature_id) as ncount FROM signatures WHERE UNIX_TIMESTAMP(DATE) >= UNIX_TIMESTAMP() - 172800");
$sigrow = mysql_fetch_array($sigcount48);
print "<p>".$sigrow["ncount"]." signatures within 48 hours.</p>";
$sigcount = mysql_query("SELECT COUNT(signature_id) as ncount FROM signatures");
$sigrow = mysql_fetch_array($sigcount);
print "<p>".$sigrow["ncount"]." total signatures.</p>";
