expire news with date

[Anon]

Hi

How do I filter news items by date??
So only news items from the last week appear.
The date is created automatically in the DB on insert using datetime.

Something like
$sql = "SELECT *
FROM home_news
WHERE date = any less than four days old.

Cheers Matt

[fitzbean]

Provided you are using a mysql TIMESTAMP field for each news item:

$sql = "SELECT *
FROM home_news
WHERE date > NOW() - INTERVAL 4 DAY

[Anon]

Having a few teething problems
I was using DATETIME in the MySQL does this work...or do I need to utilise another method.

Cheers Matt