I am working on an "announcement" system, and I want to have an expire option, so that it removes it's self from my site, but stays in the sql. I have everything ready, I just never messed with triggers before. I don't know if I should try cron at the same time..
Thanks,
Scott W.
Trigger or Cron
Moderator: General Moderators
Re: Trigger or Cron
Set the expire date and filter out expired items in your selects:
Code: Select all
select anouncement.*
from announcement
//...
where expireDate > now()
//...
Re: Trigger or Cron
Are you saying, when the page is visited, check to see if the announcement is expired? If so.. why didn't I think of that lol.