<?php global $chairs; $chairs = 0; ?>In the Body box
<?php global $chairs; $chairs += $MyRow>chairs; ?>and in the Footer Box
<?php global $chairs; echo "<div>Total chairs: $chairs</div>"; ?>
<?php if ( !$mainframe->isSite() ) { return; } $db =& JFactory::getDBO(); $query = " SELECT SUM(`chairs`) as `chair_count`, SUM(`tables`) as `table_count` FROM `#__some_table`; "; $db->setQuery($query); $data = $db->loadObject(); echo "<div>Number of chairs: ".$data->chair_count."</div>"; echo "<div>Number of tables: ".$data->table_count."</div>"; ?>
2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for
goods and services provided by ChronoEngine.com