สอบถามเกี่ยวกับการนำค่า total มาคำนวณ เพื่อหาค่าอีกค่าหน่อยครับ

6669
12979
18050
22644
23939

<?php
$sql = mysql_query("SELECT A, YEAR FROM `mt_data` WHERE $sqlm2 AND A != 'TOTAL' AND ( YEAR = '" . $year . "' OR YEAR = '" . $year2 . "' ) AND `cate_type` = '" . $cate . "' GROUP BY A ORDER BY YEAR DESC , id ASC");
while ($r = mysql_fetch_assoc($sql)) {
    $sql2 = mysql_query("select (select sum(B) from mt_data where A='" . $r['A'] . "' AND A != 'TOTAL' AND cate_type = '" . $cate . "' AND YEAR = '" . $year . "' AND $sqlm2) AS total1,(select sum(B) from mt_data where A='" . $r['A'] . "' AND A != 'TOTAL' AND cate_type = '" . $cate . "' AND YEAR = '" . $year2 . "' AND $sqlm2)  AS total2");
    $num = mysql_num_rows($sql);
    if ($num > 0) {
        while ($rr = mysql_fetch_assoc($sql2)) {
            $total = $total + $rr["total1"];
            $total2 = $total2 + $rr["total2"];
            $market = ($rr['total1'] * 100) / $total;
            ?>
            <tr>
                <td class="pds-15"><a href="<?php echo _path('search', $r['A']) . '/' . $showyear . '/' . $r['month']; ?>" title="<?php echo $r['A']; ?>" title="<?php echo $r['A']; ?>"><?php echo $r['A']; ?></a></td>
                <td class="pds-15"><?php echo number_format($rr['total1']); ?></td>
                <td class="pds-15"><?php echo number_format($rr['total2']); ?></td>
                <td class="pds-15"><?php echo number_format($market, 1); ?></td>
            </tr>
            <?php
        }
    } else {
        ?>
        <tr>
            <td colspan="6" class="pds-15 text-main">ไม่พบ</td>
        </tr>
        <?php
    }
}
?>
<tr>
    <td class="pds-15">TOTAL</td>
    <td class="pds-15"><?php echo number_format($total); ?></td>
    <td class="pds-15"><?php echo number_format($total2); ?></td>
</tr>