title: MySQL, passing a AUTO_INCREMENT to another table
body: <p>Since the other one was answered correctly and i got a new idea for solving my problem (that's not really like the case under) i start a new thread.</p>
  
  <p>Same example, the cds.id is AUTO_INCREMENT and these two tables does not really have any relations, is there any way to post the generated id to the languages table?</p>
  
  <pre><code>Table for CDs (cds):
  id | type
  -----------------------
  1  | CD  
  2  | LP  
  3  | CD  
  
  Table for names:
  cd_id | language | name
  -----------------------
  1     | fi       | AAA
  1     | de       | AAACHTUNG
  3     | en       | CCC
  </code></pre>
  
  <p>Now the SELECT would be really simlple and the structure is better,
  If i now have e form for creating a CD, like</p>
  
  <pre><code>&lt;input... &gt; = the name -&gt; 'best of XX'
  &lt;select...&gt; = language -&gt; 'en'
  &lt;select...&gt; = type     -&gt; 'CD' 
  </code></pre>
  
  <p>and i do a post, how can i do a multiple insert?
  The insert to these tables should be...</p>
  
  <pre><code>INSERT INTO cds ('', 'CD');
  INSERT INTO languages ('*the generated id in table above*', 'en', 'best of XX');
  </code></pre>