Hi,

I am looking at creating a function that pulls out x number of products randomly from the current category and its subcategories. I want to write some php/sql code that gives me an the title, the thumnail image and the price as well as the link through to the full product. I have looked at featured product sidebox and similar but they rely on products being set up as featured. I would like to write it independently and also get products from subcategories. So

- can I write a query that gets me all products from a given category and its subcategories?


I can then randomly select from the returned recordset although pointers as how to do that would be appreciated

Thanks

Christoph