title: MySQL Error: Incorrect usage of UPDATE and LIMIT
body: <p>How can I correct this problem so that my MySQL code works correctly.</p>
  
  <p>Here is my MySQL code that gives me the problem.</p>
  
  <pre><code>$q = "UPDATE users INNER JOIN contact_info ON contact_info.user_id = users.user_id SET active.users = NULL WHERE (email.contact_info = '" . mysqli_real_escape_string($mysqli, $x) . "' AND active.users = '" . mysqli_real_escape_string($mysqli, $y) . "') LIMIT 1";
  $r = mysqli_query ($mysqli, $q) or trigger_error("Query: $q\n&lt;br /&gt;MySQL Error: " . mysqli_error($mysqli));
  </code></pre>