Displaying a Total from a Table Column

Hi there.

Thanks for posting!

The way I would do this is with a "total" variable sort of like this:

<?php $total = 0; ?>

<?php foreach ($serverRecords as $record): ?>
<?php $total .= $record['number_boxes']; ?>
<?php endforeach ?>

Does that make sense? Basically, you create one variable and then each time you cycle through the foreach loop, it adds the value of number_boxes for that record to the running total.

Anywhere after that loop you can display or use $total in an equastion. How does that sound?

Let me know what you think :).

Without seeing the viewer file it's hard to know what the problem might be.

If you know MySQL, though, you can use that directly. When you load the viewer_functions.php file it automatically connects to the CMSB database for you. So you can then just call mysql_query() and other functions as needed.

Or you can use a CMSB database function to return the first record like this:

require_once "cmsAdmin/lib/viewer_functions.php"; // update to match your server path
list($total) = mysql_query_fetch_row_array(" SELECT SUM(weight) AS total FROM `cms_weight_management`");
print "Total: $total";

Make sure you have a recent version of CMSB and that you replace cms_ with your CMSB table prefix.

Hope that helps!