Greetings, I am facing an issue with my database where I utilize a link table to establish connections between products and categories.
The relational structure is as follows:
Product ProductCategories Category
Id Id Id
Name ProductId Name
CategoryId
Therefore, the productCategory table serves the purpose of linking Products to Categories.
My current challenge revolves around retrieving all Products categorized under the category with the ID of 1.
I have attempted the following code to achieve this but unfortunately, it does not appear to be functioning correctly:
$models = Products::model()->with('productcategories')->findByPk(1);
Below are the relationships defined within the Products model:
public function relations()
{
return array(
'productcategories' => array(self::HAS_MANY, 'Productcategories', 'ProductId'),
);
}