title: mysql relationship between two tables
body: <p>I need a hand on this...</p>
  
  <p>I want to create a relationship between two tables:</p>
  
  <p>table called films, and a table called directors. </p>
  
  <p>On a form, I've created director_id as a foreign key in the films table, but I don't know how to proceed.</p>
  
  <p>It works like this: I have a form, and it asks me to input a file name, to upload the film, and to input the director name, but the foreign key is director id. In the directors table there is only two columns, director id and director name. </p>
  
  <p>How can I add the director name on the form and INSERT IN the director table having a relation with the director id?</p>
  
  <p>I know I'm explaining it really bad, but it's because I don't know much what am I doing and I'm starting to have a huge mess in my head...</p>
  
  <p>Anyone understands what I am trying to ask? :(</p>
  
  <p>Thank you</p>