title: Is this possible to update the database in a schedule using php?
body: <p>For example, I got a table like this:</p>
  
  <p><code>Activities:
  id
  start_time
  status</code></p>
  
  <p>And I would like to insert an activity, start in <code>2013-01-01</code>, <code>status</code> is <code>0</code>,
  if the server become <code>2013-01-01</code>, the <code>status</code> will become <code>1</code>.</p>
  
  <p>I can write a simple scheduler a <code>java</code> programme to execute a <code>schedule</code> action, when the <code>php</code> programme is submit to the database. Also, I can have a long polling <code>php</code> programme to check so. Also, I can have a database trigger to do so. I can also check if there any any records need to execute which time the user called.....</p>
  
  <p>But is there anyway </p>
  
  <pre><code>1. to use php ONLY, no database trigger is prefered.
  2. the schedule can content can be editable easier. 
  3. no need the client to driven the change status execution, if no body is calling the requested .php, status can also changed in database, it changed based on time, not by event
  </code></pre>
  
  <p>For example of point 2, I may have a table that store after execute status, for example, it can change to status to <code>3</code>, instead of <code>1</code>. The table is something like this:</p>
  
  <p><code>Activity_executes: id activities_id change_status_code</code></p>