title: Select from drop-down menu and reload page
body: <p>I've got a table that populates data from a MYSQL database and populates a drop-down menu from the same database.  I have the drop down menu and table just fine, I would like to be able to choose which data I show in the table however.  </p>
  
  <pre><code>&lt;select name = 'peer-id' method='post' style = 'position: relative'&gt;
          &lt;?php
          while ($content = mysql_fetch_array($peer)) {
              echo "&lt;option value='" . $content['Peer'] . "'&gt;" . $content['Peer'] . "&lt;/option&gt;";
          }
          $results = mysql_query("SELECT Destination FROM rate  ");
          ?&gt;
      &lt;/select&gt;
  </code></pre>
  
  <p>That's what I have for the select box.  How can I get the choice from that and save that as a variable and refresh the table data?</p>
  
  <p>I need to clarify that this will change that current data</p>
  
  <pre><code> #Data#Data#Data
   #Data#Data#Data
   #Data#Data#Data
  </code></pre>
  
  <p>Then choose drop down choice and I want it to show new data</p>
  
  <pre><code> #Data2#Data2#Data2
   #Data2#Data2#Data2
   #Data2#Data2#Data2
  </code></pre>
  
  <p>So it's going to need to load a new page or refresh some how because it's changing via PHP and not javascript.</p>