add all the mysql rows

[ayushchd]

$a = "select * from shares where user = '". $_COOKIE['user']."';";
$ab = mysql_query($a);
$abc = mysql_numrows($ab);
while ($row = mysql_fetch_assoc($ab)) {
$query= "select * from listedcomp where company='" . $row['company'] . "'";
$result = mysql_query($query);
$rows = mysql_fetch_assoc($result);
$shares = $rows['shares'];

$closing = $rows['closing'];
$qty = $row['quantity'];
$curdate = date("F j, Y");
$value = $closing * $qty;
$book = $value * 0.01;
$pmt_amt = $value + $book;
?>
<link type="text/css" rel="stylesheet" href="css.css">
<div class="querywhite">
You shares information : <p>
<table width="100%" class="shares">
<tr bgcolor="#717593">
<td height="21">&nbsp;
Company
<div align="center"/>
<div align="center"/>
</td>
<td>&nbsp;Date
<div align="center"/> </td>
<td>&nbsp;
Quantity
<div align="center"/>
<div align="center"/> </td>
<td>&nbsp;
Total Transaction Value
<div align="center"/>
<div align="center"/> </td>
<td>&nbsp;Bookerage
<div align="center"/> </td>
<td>&nbsp;
Pmt
<div align="center"/>
<div align="center"/> </td>
<td>&nbsp;Closing Price
<div align="center"/> </td>
</tr>
</div>
<div class="queryblack">
<tr bgcolor="#FFFFFF">
<td height="21"> <div align="center" class="queryblack"/>&nbsp; <? echo $row['company'];?>
</td>
<td> <div align="center" class="queryblack"/>&nbsp; <? echo $row['date'];?>
</td>
<td> <div align="center" class="queryblack"/>&nbsp; <? echo $row['quantity'];?>
</td>
<td> <div align="center" class="queryblack"/>&nbsp; <? echo $row['transaction'];?>
</td>
<td> <div align="center" class="queryblack"/>&nbsp; <? echo $row['bookerage'];?>
</td>
<td> <div align="center" class="queryblack"/>&nbsp; <? echo $row['pmt'];?>
</td>
<td> <div align="center" class="queryblack"/>&nbsp; <? echo $row['closing'];?>
</td>
</tr>
</div>
</table>

Now, I have to echo the sum of all the $row['pmt'];

How do i do that?

[dreamcatcher]

select *,SUM(pmt) AS total_sum from listedcomp where

Then use:

<?php echo $row['total_sum'];?>

Should be ok I think.

dc