Only show items upto 3days old

[queerfm]

Hi am trying to make a page that will show the last 3 days of news.

however i am not sure how to limit it to only show items that are newer then 3 days.

the dates are stored in the database like 2008-08-10 14:05:01 under the row date_time

Any help would be great

[queerfm]

I played around with it and got it to work... If any one needs to know how to do it here is a sample it may not be the best way to do it but it works...

$query = "SELECT * FROM news WHERE date_time BETWEEN CURRENT_DATE-3 AND CURRENT_DATE ORDER BY id DESC";