Merci pour la réponse.
J'ai bien la table de jointure categories_products
et voilà la table des requêtes
(default) 6 queries took 14 ms
Nr Query Error Affected Num. rows Took (ms)
1 SHOW FULL COLUMNS FROM products 19 19 6
2 SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; 1 1 1
3 SHOW FULL COLUMNS FROM categories 9 9 3
4 SHOW FULL COLUMNS FROM categories\_products 5 5 2
5 SELECT Product.id, Product.name, Product.slug, Product.small\_price, Product.medium\_price, Product.large\_price, Product.discount\_percentage, Product.small\_image\_url, Product.large\_image\_url, Product.description, Product.extended\_description, Product.additional\_description, Product.active\_for\_home\_page, Product.position\_home\_page, Product.active\_small\_price, Product.active\_medium\_price, Product.active\_large\_price, Product.active, Product.gift\_id FROM products AS Product WHERE Product.id = 20 LIMIT 1 1 1 1
6 SELECT Category.id, Category.name, Category.slug, Category.description, Category.description\_is\_image, Category.image\_url, Category.type, Category.popularity, Category.active, AppModel.id, AppModel.category\_id, AppModel.product\_id, AppModel.position, AppModel.popularity FROM categories AS Category JOIN categories\_products AS AppModel ON (AppModel.product\_id = 20 AND AppModel.category\_id = Category.id) 1 1 1
Je teste la dernière requêtes sur mysql, il m'affiche les informations nécessaires. Mais sur le controleur, il me donne juste l'information sur la catégorie.
J'ai même fais $this->Category->recursive=2;
merok
