sum column table(not in db)
<p>my table calculates total without tax from total inclusive of tax the snippet of my page is available below
getting the total of the inclusive column is easy with the SUM(column) query
i however want to calculate sum total(without tax ) which is not in the db
for this column i am using                        </p>

<pre><code>&lt;?php
$inclusive=$row_returns['Total'];
$total=$inclusive*0.86;
echo $total;
?&gt;
</code></pre>

<p>and for the total inclusive of tax i am using<code>{returns.Inclusive}</code>
where its total is obviously </p>

<pre><code>&lt;?php     
$result = mysql_query('SELECT SUM(Inclusive) AS tot FROM returns');
$row = mysql_fetch_assoc($result); 
$sum = $row['tot'];
echo $sum;
?&gt;
</code></pre>
