title: How to insert data from a HTML Select Form into a SQL Database?
body: <p>I have some code with a HTML Select Form. How can I insert this into a MySQL Database? Who can help my?</p>
  
  <h1>THE FORM</h1>
  
  <pre><code>&lt;select name="fileCategory"&gt;
      &lt;?php
  
      $sqlCategorieen = mysqli_query($MySQL, "SELECT * FROM `categorieen`");
      foreach($sqlCategorieen AS $sqlCategorieData) {
          echo '&lt;option value="'.$sqlCategorieData['categorieId'].'"&gt;'.$sqlCategorieData['categorieNaam'].'&lt;/option&gt;';
      }
  
      ?&gt;
  &lt;/select&gt;
  </code></pre>
  
  <h1>THE MYSQLI_QUERY</h1>
  
  <pre><code>$sqlUpdateBestanden = mysqli_query($MySQL, "UPDATE `bestanden` SET `bestandTitel` = '".$bestandTitel."' `bestandCategorieId` = '".$bestandCategorieId."' WHERE `bestandId` = ".$_GET['file']."");
  if($sqlUpdateBestanden) {
      echo 'Opslaan Gelukt!';
      header('refresh:1');
  } else {
      echo 'Opslaan Niet Gelukt!';
  }
  </code></pre>
  
  <p>Who can help my with this problem? Thank you!</p>
  
  <p><em>Sorry for my English! It's so bad! Sorry!</em></p>