title: How to update SQL date using NOW()
body: <p>Basically I have a simple login form. In the database I have a 'last_logged' column and would like to update it with the current date and time every time someone logs in.</p>
  
  <p>I currently have this query:</p>
  
  <pre><code>    UPDATE users SET last_logged = "NOW()" WHERE id = 1
  </code></pre>
  
  <p>But it doesn't update the column to the current date. Any ideas why?</p>