6 replies to this topic

[EchoGuns]

As the topic states Im trying to find a way to display that on a page. I have searched for a while and all I have been able to find is a way to display the stock level of a product.

Any help with this would be appreciated.

[germ]

<?php echo tep_get_products_stock($product_id); ?>

[germ]

Disregard my last post.

Stupid should hurt...

[germ]

<?php
$categories_array = array();
tep_get_subcategories($categories_array);
$n = count($categories_array);
$total = 0;
for ( $i = 0 ; $i < $n ; $i++) {
  if ( ! tep_has_category_subcategories($categories_array[$i]) ) {
	 $total += tep_count_products_in_category($categories_array[$i]);
  }
}
echo $total;
?>

[EchoGuns]

Thanks, that's exactly what I was looking for. What about taking that another step forward, is there also a way to show total number of catgories and manufacturers?

[germ]

New code:

<?php
  $categories_array = array();
  tep_get_subcategories($categories_array);
  $n = count($categories_array);
// Total categories = $n
  $total = 0;
  for ( $i = 0 ; $i < $n ; $i++) {
	if ( ! tep_has_category_subcategories($categories_array[$i]) ) {
	  $total += tep_count_products_in_category($categories_array[$i]);
	}
  }
// Total products = $total
  $m = 0;
  $manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS);
  if ($number_of_rows = tep_db_num_rows($manufacturers_query)) {
	while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {
	  ++$m;
	}
  }
//Total manufacturers = $m
?>

After that code executes:

To display total categories:

<?php echo $n; ?>

To display total products:

<?php echo $total; ?>

To display total manufacturers:

<?php echo $m; ?>

[EchoGuns]

Worked perfectly.

Thanks Jim