Jump to content
Sign in to follow this  
ringo667

Category image from product within it

Recommended Posts

I have insalled this adon:

http://addons.oscommerce.com/info/9327

 

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  

×