have you tried this query on the details page:
SELECT ps3_categories.CategoryName
FROM ps3_categories
INNER JOIN ps3_productcategories
ON ps3_categories.CategoryID = ps3_productcategories.ProductCategoryID
WHERE ps3_productcategories.ProductID = $_GET['ProductID']