How to post the result of this dropdown into an sql table?
<pre><code>&lt;?php   
    $dbc = mysqli_connect("localhost","root","","bce_db");  
</code></pre>

<p>connection</p>

<pre><code>    $query = "SELECT assignee_code,assignee_name FROM assignees";
</code></pre>

<p>getting data from the data base  </p>

<pre><code>    $sql = mysqli_query($dbc,$query);

    if(mysqli_num_rows($sql)){

        $select = '&lt;select name = "select"&gt;';//dropdown created

        while($rs = mysqli_fetch_array($sql)){
          $select.='&lt;option value = "'.$rs['assignee_code'].'"&gt;'.$rs['assignee_code'].'&lt;/option&gt;';
         }
    }
    $select.='&lt;/select&gt;';//dropdown ended..

    //I used the $POST method by linking it to other php page, but it returns undefined variable
    echo $select;
 ?&gt;
</code></pre>

<p>How to post the value of the dropdown in table?</p>