such that table:
Code: Select all
id num1 num2 num3
1 3 2 4
2 2 2 3
3 4 1 0Code: Select all
num1 num2 num3
9 5 7Moderator: General Moderators
Code: Select all
id num1 num2 num3
1 3 2 4
2 2 2 3
3 4 1 0Code: Select all
num1 num2 num3
9 5 7Code: Select all
<?php $i=0;
do {
$i++; ?>
<tr><td><?php echo $row_rsRecordSet['col1']; ?></td>
<td><?php echo $row_rsRecordSet['col2']; ?></td>
<td><?php echo $row_rsRecordSet['col3']; ?></td>
<td>Subtotal=<?php $sums[$i]=array_sum($row_rsRecordSet['col1'],$row_rsRecordSet['col2'],$row_rsRecordSet['col3']); echo $sums[$i]; ?></td></tr>
<?php } while ($row_rsRecordSet = mysql_fetch_assoc($rsRecordSet)); ?>
<tr><td>Grand Total: <?php echo array_sum($sums); ?></td></tr>Code: Select all
<?php
$col1 = 0;
$col2 = 0;
$col3 = 0;
while ($row = mysql_fetch_array($result))
{
$col1 += $row['col1'];
$col2 += $row['col2'];
$col3 += $row['col3'];
}
$grandtotal = $col1 + $col2 + $col3;
echo "Col 1 total is $col1, Col 2 total is $col2, Col 3 total is $col3.<br />\n";
echo "The grand total is $grandtotal.<br />\n";
?>Code: Select all
mysql> create table sumNumbers(
-> n1 int,
-> n2 int,
-> n3 int);
Query OK, 0 rows affected (0.48 sec)
mysql> insert into sumNumbers values (3, 2, 4), (2, 2, 3), (4, 1, 0);
Query OK, 3 rows affected (0.06 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> select sum(n1), sum(n2), sum(n3) from sumNumbers;
+---------+---------+---------+
| sum(n1) | sum(n2) | sum(n3) |
+---------+---------+---------+
| 9 | 5 | 7 |
+---------+---------+---------+
1 row in set (0.00 sec)Code: Select all
mysql> create table sumnumbers(
-> n1 int,
-> n2 int,
-> n3 int);
Query OK, 0 rows affected (0.20 sec)
mysql> insert into sumnumbers values (3,2,4), (2,2,3), (4,1,0);
Query OK, 3 rows affected (0.08 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> select sum(n1), sum(n2), sum(n3) from sumnumbers WHERE n3 != 0;
+---------+---------+---------+
| sum(n1) | sum(n2) | sum(n3) |
+---------+---------+---------+
| 5 | 4 | 7 |
+---------+---------+---------+
1 row in set (0.03 sec)