Remove entries based on date?

[WebmasterJoe]

I need to remove entries from a calendar once a certain date has passed. I'm thinking that the query should look something like this:

UPDATE calendar SET entrydeleted = '1' WHERE currentdate < 'entrydate'

I'm guessing that I just need to have some value in the place of 'currentdate', but I don't have much knowledge of how dates work with php so if someone could help me out with this query I'd appreciate it.

Thanks,
WebmasterJoe

[ereptur]

Actually the SQL Language has some very powerful date manipulation.

Try something like this:

$query = "UPDATE calendar SET entrydelted = 1 WHERE DATE_SUB(entrydate,INTERVAL 1 DAYS) != CURRENT_DATE()";