I have an SQL query that calculates a word count multiplied by a fixed figure:
Code: Select all
...$pricegross = ($row_rsInvPending['projanalysis_total']*$row_rsInvPending['costbase']);...Code: Select all
<?php echo number_format($pricegross, 2, '.', ''); ?>I then total up $pricegross for all records:
Code: Select all
.....SELECT SUM(projanalysis_total) as total_pricegross...($pricegross) 1. £2.295
($pricegross) 2. £2.295
There are both displayed as £2.30, which is what I want
Then the total ($total_pricegross) shows up as £4.59, but what I want is: £4.60
Is this possible?....Hope this is clear?!