PHP从选择框中获取选定的值？

Question

This is my code for get database data to select box and i wanna get the seleceted value.I tries many ways but im missing something. help me

<form id="search" action="" method="post" >
   <select name="owner" id="owner">
   <?php 
      $sql = mysql_query("SELECT designation FROM designation");
      while ($row = mysql_fetch_array($sql)){
      echo '<option value="'.$row['designation'].'">'.$row['designation'].'</option>';
      }
      ?>
   </select>
   <input type="submit" value="Search">
</form>

Answer 1

As you didn't specify an action for your form, the default will be to send the post values to the same page.

See this for more information about action value.

So, in the same page you have the form, you should add a

if(isset($_POST['owner']))
{
    // Do some stuff
}
else
{
    // Print the form
}