title: Is it possible to sort MySql results with select dropdown list?
body: <p>I'm a project about an online publication system and in this website there are users . I have already get MySql results on my website, for some reason, the results are random. I want to sort users database result with a <strong>drop down</strong> list using the select, option tag...what should I use to get this function works ? 
  Here is my code for what I want to sort by  :</p>
  
  <pre><code>    &lt;form&gt;
      &lt;label&gt;Sort By:&lt;/label&gt;
          &lt;select name="sort" id="sort" style="float: left;"&gt;
              &lt;option value="ID"&gt;Id Number&lt;/option&gt;
              &lt;option value="name"&gt;Name A-Z&lt;/option&gt;
              &lt;option value="surname"&gt;Name Z-A&lt;/option&gt;
              &lt;option value="title"&gt;Academic Title&lt;/option&gt;
              &lt;option value="department"&gt;Departments&lt;/option&gt;
  
          &lt;/select&gt;
      &lt;/form&gt;
  </code></pre>