PHP MYSQL Recent days on Market

[DaemonProjects]

Hello all,

I have a little problem I am not really sure how to do this, it would be great if it could be done from a sql statement.

I have a mysql database with over 50k records, each record has a date when it was placed in the database. I am trying to search the database by days it has been in the database.

example:
row 1 - date 12/12/2004
todays date 1/25/2008

I would like a search form that will calculate and display the months the record has been in the database.

Search: 3 months, should display all records in the last 3 months

hope this makes sense.

-D

[NogDog]

SELECT * FROM table_name WHERE date_col > DATE_SUB(CURDATE(), INTERVAL 3 MONTH)