Hi everyone,
As the product and merchant count is such a popular request, I thought I'd add it to one of the demo sites (WebPriceCheck.co.uk) and post the code here...
$sql = "SELECT COUNT(*) AS numproducts FROM products";
database_querySelect($sql,$rows);
$numproducts = $rows[0]["numproducts"];
$sql = "SELECT COUNT(*) AS numfeeds FROM feeds";
database_querySelect($sql,$rows);
$numfeeds = $rows[0]["numfeeds"];
print "Search or browse our catalogue of ".number_format($numproducts)." products from ";
print "<a href='".($config_useRewrite?"merchant/":"merchants.php")."'>".$numfeeds." online stores</a>";Simply paste the code above into index.php as required...
Cheers,
David.