Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Sign in to follow this  

Category image from product within it

Recommended Posts

I have insalled this adon:



It works fine, but i need a litle extension


i want to show radmom Image in the subcategory above the Product List.


How must i change the Database request?


i have try this, but it doesn´t work:

  $products_query = tep_db_query("SELECT p.products_image FROM products_to_categories cp inner join products p on cp.products_id = p.products_id and p.products_status = 1 and p.products_image is not null WHERE cp.categories_id ='".(int)$catid."' ORDER BY RAND() LIMIT 3");

thx for help




Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this