title: sum of column php/mysql
body: <p>Trying to figure out why I am unable to grab the sum of a column.  In mysql column is Decimal(65,2) - not sure if that causes any conflict, and $ signs have been removed as they were initally there from csv import export but ran replace and all are clear.</p>
  
  <pre><code>$sql = "SELECT DISTINCT ContactId, Date, First_Name, Last_Name, Referral_Partner,
  Sale_Total, SUM(Sale_Total) AS sum_ttl 
      FROM PTLS1117v2 
       WHERE Referral_Partner = '$refpart' 
        AND Date BETWEEN '$pdate' AND '$pdate2'";
  </code></pre>