most viewed

[100asa]

Is there a box (or mod) to show most viewed products, related to the same category?

[100asa]

Is there a box (or mod) to show most viewed products, related to the same category of product that I'm seeing?

[misty]

CLOSEST to your request at
http://www.zen-cart.com/index.php?ma...roducts_id=720

[100asa]

it's a wonderful mod, but it show only last viewed item during browsing shop; instead i would mod that show most viewed item related to categories of item I'm seeing.
As stats_products_viewed in admin.

[misty]

You can search in downloads/Free software addons...
link top of this page.. dont see one myself that meets your exact requirements so you can advertise in Commercial section
for zencart coder to create one..

[100asa]

I've just created a query like this:

$most_view_query = "select distinct p.products_id, p.products_image, pd.products_name, pd.products_viewed, p.products_price, p.products_ordered

              from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "

                  . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c

              where p.products_status = '1'

                            and p.products_id = pd.products_id

              and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

              and p.products_id = p2c.products_id

              and p2c.categories_id = c.categories_id

              and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id)

              order by pd.products_viewed desc

              limit " . MAX_DISPLAY_BESTSELLERS;




   $most_view = $db->Execute($most_view_query); 

but no products show in box
Why? thanks for help