title: Grouping a SQL statement and extracting info via PHP
body: <p>I have a table that is structured with data like this: </p>
  
  <pre><code>TransactionID | saleID | productType | Price
  1             | 1001   | subtotal    | 19.50
  2             | 1001   | tax         | 3.11
  3             | 1002   | subtotal    | 19.50
  4             | 1002   | tax         | 3.11
  </code></pre>
  
  <p>I am trying to extract the value of the Price field, per SaleID that match numbers, and have it put into  PHP variables for subtotal &amp; tax.  </p>
  
  <p>Any idea?</p>