Deleting files over 2 weeks old.

[Josh]

I'm working on a script that will use a mySQL database to house the information. I have the script written and the database created, but need to find an easy way to remove entries that are over 2 weeks old.

What would be the easiest way to acheive this?

Thanks
~Josh

[Bealers]

delete from table where date > some_date

[Mike Sullivan]

I might be wrong, but shouldn't it be:

where date < some_date

??

[Josh]

Thanks guys...

I didn't even think of that method and the only other ones people suggested involved detailed calculations ;)

Thanks again,

~Josh

[Bealers]

yep <

NOT >

pesky keyboard ;)

[Mike Sullivan]

Yes, damn things aren't telapathic :mad:

:D

[Stallion]

I just hope there aren't any of those "slips" in Back-End! ;-)

[Menno]

Yeah, that would be a nice disaster :D

[Bealers]

...........

[Tim Mousel]

$currenttime = time();

$sql = "DELETE FROM table WHERE expires < $currenttime";