Display Products In Parent Category

[grodo]

Hello All! I have searched the forums and internet for days now and still didnt find anything for this subject. Im using OScommerce 2.2MS and Im having trouble display some products in the parent categories.

 

I'm not the best at explaining so I will create a ASCII picture example.

 

I want all products that have the parent category Cars, so my results should be the product id's for:

 

Escort 1.3

Escort 1.4GHIA

Escort 1.6L

Almera 1.5S

Almera 1.5SE

 

 

Cars

----->Ford

------------>Escort

-------------------->Escort 1.3

-------------------->Escort 1.4GHIA

-------------------->Escort 1.6L

----->Nissan

----------->Almera

-------------------->Almera 1.5S

-------------------->Almera 1.5SE

-------------------->

Trucks

----->ERF

----->Mercedes