title: Price low - high / high - low filter PHP/Mysql
body: <p>i am looking for a way to create a filter (select dropdown menu) that selects my products based on price.<br/></p>
  
  <p>I know this is perfectly possible with a query like this:
  <br/></p>
  
  <pre><code>SELECT * FROM products ORDER BY price ASC 
  SELECT * FROM products ORDER BY price DESC 
  </code></pre>
  
  <p><br/></p>
  
  <p>But the problem is that i do not want to pass GETS to the url to select the query.
  <br /></p>
  
  <p>Is it possible to execute a jquery command to populate the results?
  <br/></p>
  
  <p>This is my select:</p>
  
  <pre><code>&lt;select name="filter"&gt;
  &lt;option value="lowHigh"&gt;Price: low - High&lt;/option&gt;
  &lt;option value="highLow"&gt;Price: High - Low&lt;/option&gt;
  &lt;/select&gt;
  </code></pre>
  
  <p>Thanks in advance.</p>