Visible Counter of Product Sold

[jmp01]

Newbie...
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:

<?php
$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"

Any ideas?

[AmandaGero]

you could use

$chk_products_ordered = zen_products_lookup((int)$_GET('products_id'], 'products_ordered');

Then echo the $chk_products_ordered where you want to display it ...

[jmp01]

OK... so here is the script that I inserted into my main page:

<?php
$chk_products_ordered =zen_products_lookup((int)$_GET('products_id'], 'products_ordered');
echo '<div class="row"><span class="left">' . $chk_products_ordered . ' </span><span class="right">' . $products->fields['count'] . '</span></div>';
?>

The Page is coming up blank...
Que` Pasa?

[AmandaGero]

i just added a new contribution, try this:


http://www.zen-cart.com/forum/showthread.php?t=162191

[Ajeh]

Try this instead:
<?php
define('TEXT_QTY_SOLD', 'Number Sold: ');
$chk_products_ordered = zen_products_lookup((int)$_GET['products_id'], 'products_ordered');
echo '<div class="row"><span class="left">' . TEXT_QTY_SOLD . $chk_products_ordered . '</span></div>';
?>