I'm not sure if this is a PHP or SQL question, as they sort of go hand-in-hand here.

I've got a mysql table named closedtickets with many entries in it. One of the columns is called "closed" and contains the unix timestamp (reported by PHP's time() function at the time of creation)

I'm trying to create some script that returns something like "15 records closed in the past 10 days."

I guess I need something to the effect of
Code:
$backthen = mktime(0,0,0,date("m"),date("d")-10,date("Y"));
and then an SQL query of something like
Code:
SELECT COUNT(closed) FROM closedtickets WHERE closed>$backthen
I'm not really familiar with the syntaxes of either language and wondering if someone could help me out with this.