Hey guys, i've this theme of the week script, easy, just post like normally, save in database and echo it in a column.
But since its theme of the week, i would like it to automatically renew the value to say "none" or "not set" after a week. I know cron jobs could do this but is there another way? [Running in PHP]
You could keep it in the database along with the date of saving and determine if it expired by comparing that date plus one week with current date.
Cron job would be the optimal solution but if you can't do that you could have your main page check if it's time to "renew" on every page load. It's a lot less efficient but it's an alternative if you don't have access to cron jobs.
Add an expires column to the database and set it to now + 7days. Default it to a date way in the future 9999-12-31 for Mysql. Then select based on the expiry being > now.
As a side benifit you can easily implement theme of the day, month, season, year... etc.