title: updating on multiple tables
body: <p>I have two tables in mysql that are "users" and "users_info" - the first contains the login data, such as email and password, and name.</p>
  
  <p>and the second table that contains more information, like address, dob, bio, etc.</p>
  
  <p>Now, I am working on an admin panel in which I can modify any information regarding those users. To get the data, I am using a join, but what about saving?</p>
  
  <p>How can I save data regardless of its table? if it was just one table I would have done (in PHP):</p>
  
  <pre><code>$values = Array(
    "email" =&gt; "foo@test.com", //this goes into "users"
    "name" =&gt; "john", //this one, too
    "bio" =&gt; "i is cool" //this one should to go users_info!!
  );
  
  foreach($values as $k=&gt;$v) {
    $query = " UPDATE users SET '$k'='$v' WHERE id=7653 ";
  }
  </code></pre>
  
  <p>this will give an error because "bio" is not a column inside users_info. Any ideas?</p>
  
  <p>Thanks in advance.</p>