Number of posts in last 30 days...

[dontpanic]

Hi all,

I've been trying to figure out how to get the query written so that I can show the total number of posts in the past 30 days.

This is what I have thus far, which I think should work if the date format was standard MySQL instead of the dateline format.

PHP Code:

// get posts over the past 30 days
$countrecentposts=$DB_site->query_first('SELECT COUNT(*) AS 30recent FROM post WHERE TO_DAYS(NOW()) - TO_DAYS(dateline) <= 30');
$total30recent=number_format($countrecentposts['30recent']); 


And then, I am using the $total30recent in my forums_home template where I want it to appear.

Any ideas on this one?? I know the problem is because the date is not stored in the normal date format...