Category image from product within it

[ringo667]

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