How To Get Total Products On Front Pages?

Hi all,

i want total product’s number to show on front pages.

it there any code that i can use ?

Anyone can help

thanks

Adam

[quote name=‘martin1979’ timestamp=‘1398176046’ post=‘182087’]

Hi all,

i want total product’s number to show on front pages.

it there any code that i can use ?

Anyone can help

thanks

Adam

[/quote]



For the latest version create a new block with smarty support and add the following code:


<br />
Total amount of products: {"SELECT COUNT(product_id) FROM ?:products"|db_get_field}<br />

```<br />
<br />
Bad style, CS-Cart architects hate such code, but it will work. <img src="upload://rA9Qa8gnUPZzRZRdI8kt3dpjkrs.png" class="bbc_emoticon" alt=":)">

[quote name=‘eComLabs’ timestamp=‘1398178347’ post=‘182091’]

For the latest version create a new block with smarty support and add the following code:


<br />
Total amount of products: {"SELECT COUNT(product_id) FROM ?:products"|db_get_field}<br />

```<br />
<br />
Bad style, CS-Cart architects hate such code, but it will work. <img src="upload://rA9Qa8gnUPZzRZRdI8kt3dpjkrs.png" class="bbc_emoticon" alt=":)"><br />
[/quote]<br />
<br />
yes, it works, thanks