I'd like to set up a counter for each item sold, so that I can display it anywhere on the site. I have tried:
$products = $db->Execute("select count(*) as count from " . TABLE_PRODUCTS . " where products_ordered > '0'");
define('PRODUCTS','The total number sold so far is ');
echo '<div class="row"><span class="left">' . PRODUCTS . ' </span><span class="right">' . $products->fields['count'] . '</span></div>';
But this counter gets stuck at "1"