title: INSERT INTO two different tables, but have the same ID?
body: <p>I have a database of Users and another table for Teachers. Teachers have all the properties as a user but also an e-mail address.  When inserting into the DB how can I insert the info, ensuring that the ID is the same for both? </p>
  
  <p>the ID currently is on automatic incrament. </p>
  
  <p>this is what I have at the moment: </p>
  
  <pre><code>$sqlQuery="INSERT INTO user(firstName,lastName,DOB,title,password,classRoomID) 
      VALUES('$myFirstName','$myLastName','$myDOB','$myTitle','$newPassword','$myClassRoom')";
      $result=mysql_query($sqlQuery);
  
  $sqlQuery = "INSERT INTO teacher(email) VALUES ('$myEmail')";
  $result=mysql_query($sqlQuery);
  </code></pre>
  
  <p>thank you! </p>