News page

[Anon]

I need to automize the news on a page. I mean... I have some stuff in a database and I want it to appear ONLY if it's not older then 5 days. Otherwise I don't want it to be displayed.

I'd naturally need a field with the insert date, taht's OK.

But how can I put the statement...

SELECT NEWS WHERE DAYTIME "LESS THEN 5 DAYS AGO"

I mean... what should I put instead of "LESS THEN 5 DAYS AGO"?

Or is there any usefull script for this?

[Anon]

define a var, call it
$now = time().
$number_of_days = 5
$exptime = $number_of_days 24 60 * 60

SELECT NEWS FROM ... WHERE daytime + $exptime > $now

[Anon]

What kind of variable should the day and the time be?

On field type=datetime?

Thanks!