So I've worked out I'll need to be able to include a category id equal to the current_category_id in the database query that is used in the while loop tht builds the recent products. To do this I think I need to implement a table join on the query that pulls the product info to join table products with table products_to_category.

Not very good at joining tables so any pointers would be appreciated.

Once I have the current category id as a field in the while loop I'm hoping with this I should be able to output the product_info URL to the correct category??

Phil