title: Random results from mysql sum
body: <p>I'm new here, please be gentle. I have a MySQL database which stores values of customer orders woth the values formatted to 2d.p. This is the code I am using....</p>
  
  <pre><code>Select sum(Total) from invoiceitems where InvoiceNumber ='$Invoice'
  </code></pre>
  
  <p>The three values for one specific invoice are 1,080.00, 42.00 &amp; 30.00 - the result I het is a total of 73.00. Please could somebody tell me what I need to do to amend this?</p>