Topic: Syncronized action

I have a quiz with 100 questions that need to be shown once a day. I have inserted all the question in a database and there is a field published in the database as well. If the published field is true that is the question of the day that will be displayed. Any idea how can i make an automatic action that everyday at 11:59 sets false the published field and sets true the published field of the question of the next day?

Re: Syncronized action

Your best bet is to rely on your deployment operating system,  if it's Unix/Linux,  then you could create a cron job that runs a SQL script.  If your developing on a non Unix/Linux platform,  just do it by hand until you're deployed for real.

Joe got a job, on the day shift, at the Utility Muffin Research Kitchen, arrogantly twisting the sterile canvas snout of a fully charged icing anointment utensil.