title: MySQL Triggers to Disable A User Account
body: <p>I am trying to create a MySQL Trigger to disable someone's account if they have logged in to the site 3 times.  I have tried to create this trigger using the following code, but it is not setting is_active to 0 no matter what times_logged_in is.  Any help would be appreciated.</p>
  
  <pre><code>CREATE TRIGGER updateTrigger AFTER UPDATE ON users
  FOR EACH ROW
  BEGIN
  UPDATE users SET is_active=0 WHERE NEW.is_code=1 
  AND NEW.times_logged_in&gt;=3
  AND NEW.user_id=user_id;
  END;
  </code></pre>