SQL for blogs

I am looking for an SQL statement/PHP code that can tell me the blog posts from the last week. 

I have stat manager installed, but I am not sure the SQL and php to get a weekly update on numbers. Does anyone have any ideas?

The SQL query that can be used for the site stats is.

SELECT COUNT(`PostID`) FROM `bx_blogs_posts` WHERE `PostDate` > UNIX_TIMESTAMP() - 604800

That will return a count of the number of blog posts made within the last 7 days.

Deano,

Thanks for the quick response (on a Saturday)! 

What would the user link be to just show those blog posts?

Thanks again

Your will not be able to show JUST THOSE blog posts because the blogs system does not have filtering to show only posts within a date range.

So your stuck with one of these links.

http://www.yoursite.com/blogs/all_posts/

Or

http://www.yoursite.com/blogs/home/

Both of those have the most recent posts listed first.

True.

Thanks for the responses on this issue. I will let you know if I run into any more troubles, I really appreciate the help!