title: sorting by high-low price with mysql data
body: <p>Here's what I have, and what I want to do:</p>
  
  <p>I have 12 items in my MySql database. 4 products are 4.99, 4 products are 3.99 and 4 products are 2.99.</p>
  
  <p>I realize I can query the database like this, and It will give me a list of products at that price:</p>
  
  <pre><code>&lt;?php
  
  $query = "SELECT * FROM UFPProducts WHERE price = 4.99";
  $results = mysql_query ($query, $connect);
  
  while ($row = @ mysql_fetch_array($results))
  {
  
  print
  
  
  
  "&lt;div id= 'item'&gt;" .
  
  "&lt;p&gt;Product id ".$row["ProductID"]."&lt;/p&gt;".
  "&lt;p&gt;&lt;img src=".$row["Image"]."&gt;&lt;/p&gt;".
  "&lt;p&gt;&amp;pound".$row["Price"]."&lt;/p&gt;".
  "&lt;p&gt;".$row["Description"]."&lt;/p&gt;".
  
  "&lt;/div&gt;";
  }
  
  ?&gt;
  </code></pre>
  
  <p>However, what I want, is a button I can press to sort products by price.</p>
  
  <p>What's a simple way of doing this? </p>
  
  <p>Thanks</p>