Count Mysql

[duny]

Need help with this code

<?
$query = "select * from ".$prefix."items_sold WHERE artist = '$artist_login' and date = '$_GET[cur_mt]/$_GET[cur_yr]'";
$result = MySQL_query($query); 
while($rows = mysql_fetch_array($result)) { 
$f_name = $rows[file_name];
$qty = $rows[qty];
$amount = $qty * $aff_amount;
$qty = $rows[qty];
echo"
  <tr>
    <td width=3%></td>
    <td width=3%></td>
    <td width=71%><font color=white><li>$f_name</td>
    <td width=11%><font color=white>$qty</td>
    <td width=11%><font color=white>$".precisionNumero($amount, 2, true)."</td>
  </tr>";
}
?>

The out put is this

Item Name Qty Payable
file1.gif 2 $0.20
file2.gif 2 $0.20

What i want to know is how can i add up the two qty to equal 4 cause i want to add another line to say total items sold = 4

[drew010]

id say, just make a variable in there called $totalamount and each time you calculate $amount ($amount = $qty * $aff_amount😉 just add a line right after that, $totalamount += $amount;
then once the loop finishes $totalamount should have the grand total.

[Weedpacket]

Or set $total_quantity=0 before the loop, and then $total_quantity = $total_quantity+$qty inside the loop. Then $total_quantity after the loop will be all the quantities added together - i.e., the total quantity.

[rebelo]

Or how about this one:

echo "Total items sold: ".mysql_num_rows($result)."<br>";

[drew010]

ah yeah, i read that wrong, you wanted total items sold, not total $ value. do what weed said.