title: Update mysql timestamp
body: <p>I have a table with a field:</p>
  
  <blockquote>
    <p>'last_modified - timestamp NOT NULL'</p>
  </blockquote>
  
  <ul>
  <li>I set the default value to the current timestamp. However this only works when updating or inserting from phpMyAdmin and not from my script. </li>
  </ul>
  
  <p>I have tried </p>
  
  <pre><code>$sql = sprintf("UPDATE %s SET timestamp=now(), %s WHERE id='%s'", $table, $implodeArray, $_POST['id']);
  </code></pre>
  
  <p>and it still doesnt seem to work. How can I make the timestamp update when I update or insert by table from a script?</p>
  
  <p>Also heres a sample of the scripts output:</p>
  
  <blockquote>
    <p>UPDATE about SET timestamp=now(), page_header = 'Page header goes here', sub_header = 'Sub header goes here', content_short = 'This is where a short description of the about page goes', content = 'This is where the full content description goes' WHERE id='1'</p>
  </blockquote>