well i had worked on the same.
I m adding this on my product-detail.php page now.
Already there is an existing product RS so not sure how well to edit them & view the category name.
I created a new RS which had got these:
SELECT Products.ProductID, productcategories.CategoryName, Products.ProductCatID
INNER JOIN productcategories
Result seems fine, all results are shown but how do we include param variable into it to show particular product result (category name)?
All files attached also screenshot of NewRS & Existing RS for displaying product details.
I m not very sure if we need to modify existing RS or create RS for displaying category name.