Rows where date is within last 3 days!

[Anon]

I want to be able to show the latest articles that were added to the database. Basically, to show all where the date column (where we entered the date as 2002-06-29 when submitting the info) is between today and the last 3 days. That way people could see what was added within the last 3 days.

What is the MYSQL statement to do that?

Thanks!
Ryan D
Bodybuilding.com

[Anon]

There are many ways of approaching the problem. Here are a few examples:

SELECT something FROM tbl_name WHERE ((UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(msg_col)) <= 259200 )

SELECT something FROM tbl_name
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 3;

SELECT something FROM tbl_name WHERE date_col <= DATE_SUB(now(), INTERVAL 3 DAY);

Richie.
geocities.com/akindele/

[Anon]

Hooray - and none of these ways is in the SQL standard! Go MySQL!

Chris