title: PHP/ MYSQL Inserting Data Into Multiple Tables
body: <p>I am trying to add data into 3 table using PHP, atm I can only view the results of the tables that are joined . </p>
  
  <p><strong>RESULTS QUERY</strong></p>
  
  <pre><code>  $sql = mysql_query("SELECT PART_ID, PART_DESC, SERIAL_NUM, PART.RACK_NUM, PART.PART_TYPE_ID,      PART_TYPE_DESC, LOCATION
      FROM PART
      INNER JOIN PART_TYPE ON PART.PART_TYPE_ID = PART_TYPE.PART_TYPE_ID
      INNER JOIN RACK ON RACK.RACK_NUM = PART.RACK_NUM
  </code></pre>
  
  <p>This will  get all the rows from the PART table, and for each of the rows we find, match that row to a row in the PART_TYPE table (the condition being that they have the same PART_TYPE_ID). If no match between the PART and PART_TYPE tables can be found for a given row in the PART table, that row will not be included in the result. </p>
  
  <p><strong>My Insert Query This is where im having trouble</strong></p>
  
  <p>How do I add the data to the PART_ID, PART_TYPE and RACK tables?</p>
  
  <pre><code>&lt;?php 
  // Parse the form data and add inventory item to the system
  if (isset($_POST['PART_ID'])) {
      $id = mysql_real_escape_string($_POST['PART_ID']);
      $PART_DESC = mysql_real_escape_string($_POST['PART_DESC']);
      $SERIAL_NUM = mysql_real_escape_string($_POST['SERIAL_NUM']);
      $RACK_NUM = mysql_real_escape_string($_POST['RACK_NUM']);
      $PART_TYPE_ID = mysql_real_escape_string($_POST['PART_TYPE_ID']);
      $LOCATION = mysql_real_escape_string($_POST['LOCATION']);
      $PART_TYPE_DESC = mysql_real_escape_string($_POST['PART_TYPE_DESC']);
      // See if that product name is an identical match to another product in the system
      $sql = mysql_query("SELECT PART_ID FROM PART WHERE PART_ID='$id' LIMIT 1");
      $productMatch = mysql_num_rows($sql); // count the output amount
      if ($productMatch &gt; 0) {
          echo 'Sorry you tried to place a duplicate "Product Name" into the system, &lt;a href="inventory_list.php"&gt;click here&lt;/a&gt;';
          exit();
      }
      // Add this product into the database now
      **$sql = mysql_query("INSERT INTO PART (PART_ID, PART_DESC, SERIAL_NUM, RACK_NUM, PART_TYPE_ID) 
          VALUES('$id','$PART_DESC','$SERIAL_NUM','$RACK_NUM','$PART_TYPE_ID')") or die (mysql_error());**
  
  
       header("location: inventory_list.php"); 
      exit();
  }
  ?&gt;
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/jr1bn.jpg" alt="enter image description here"></p>