title: using value on select box as a input to save into sql table
body: <p>here the scene. This code below is for me to retrieve the data from table "koti_images" and display at the page in a form of select box which is already success. </p>
  
  <p>so the question is, it is possible to make sure when user select the value from the select box which is in this case is the "plan" and click save, that data will be saved in other table in mysql. I already create new table "koti_imagedigital" but i dont have idea on how to pass the value that were selected into this table. i am new into this stuff, so hope you all can help me. Thank You. </p>
  
  <pre><code>&lt;form name="form_update" method="post" action="testkoti.php"&gt;
      &lt;?php
      $con=mysqli_connect("localhost","root","","koti");
      //============== check connection
      if(mysqli_errno($con))
      {
          echo "Can't Connect to mySQL:".mysqli_connect_error();
      }
      //=============================
      //This creates the drop down box
      echo "&lt;select name= 'plan_id'&gt;";
      echo '&lt;option value=""&gt;'.'--- Please Select Plan ---'.'&lt;/option&gt;';
  
  
      $query_display = mysqli_query($con,"SELECT * FROM koti_images");
      while($row=mysqli_fetch_array($query_display))
      {
          echo "&lt;option value='". $row['file_name']."'&gt;".$row['file_name']
       .'&lt;/option&gt;';
      }
  
      echo '&lt;/select&gt;';
      ?&gt;
             &lt;div class="box-footer"&gt;
               &lt;a href="#" class="btn btn-warning"&gt;Cancel&lt;/a&gt;
                 &lt;button href = "#" type="submit" class="btn btn-primary pull-right"&gt;Save &amp; Exit&lt;/button&gt;
                &lt;/div&gt;
              &lt;/div&gt;
      &lt;/form&gt;
  </code></pre>