title: drop down menu to sort query results on a php page
body: <p>I have a simple list-type php page, which lists items according to a mysql query, like:</p>
  
  <pre><code>mysql_select_db($database_connBHN, $connBHN);
  $query_rsMarket = "SELECT * FROM my_items WHERE active=1 ORDER BY name asc";
  $rsMarket = mysql_query($query_rsMarket, $connBHN) or die(mysql_error());
  $row_rsMarket = mysql_fetch_assoc($rsMarket);
  $totalRows_rsMarket = mysql_num_rows($rsMarket);
  </code></pre>
  
  <p>then the page list these items and their description in separate tables.</p>
  
  <p>Initially this page lists these items in alphabetical order. Now I would like to put a drop down box on the top of the page, where the user could choose another two or three more sorting options, like date, or itemId, etc, which values are stored in the database.</p>
  
  <p>How could I solve this in a simple way, without leaving that page? (i.e. I do not want to create separate pages for each different result set)</p>