Determine Responses using date()?

[treeleaf20]

I insert an original post by a user into the db in the following format:

date(d, m, Y);

I allow the user to make comments to the original post. If I want to keep track of how many responses their are in a week and month how would I do that?

Thanks for the help.

[barand]

The first requirement is to store a date format that can be sorted or comapared. Preferably use mysql DATE type and store as Y-m-d.

Once you have that you can use queries with clauses such as

... WHERE MONTH(datecol) = '$monthnum'

or

... WHERE datecol BETWEEN '2005-08-15' AND '2005-08-21'

[treeleaf20]

How would I made the WHERE datecol BETWEEN '2005-08-15' AND '2005-08-21' be completely dynamic so 2005-08-15 and 2005-08-21 update every week and month?

Thanks.