title: mysql: store a DEFAULT value as a variable
body: <p>I am wondering how to store the value of a primary key, auto-incremented by "DEFAULT" so that I can insert it as a value in another table row.</p>
  
  <p>So far I have: </p>
  
  <pre><code>$sql = "INSERT INTO sales (
              sale_id,
              sale_amt,
              sale_date) 
          VALUES (
              DEFAULT,  # &lt;--- how to store the resulting value of this?
              '$amt',
              '$date'
              )";
  </code></pre>
  
  <p>I need the specific value created by "DEFAULT" to be stored, so that I can insert it into another table's row. How do I do this with either PHP or MySQL? </p>