Provide the models code On Fri, Oct 7, 2011 at 11:26 PM, khalili merouane < [email protected]> wrote:
> Hello, > > I have two tables categories and products when I try to view a > category, I just have the information in the category without > products. > > When I check the applications running I see that selects the products > but does not display > > I have the join table categories_products > and that the table queries > > > (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 > > I test the last mysql query, it m'affiche the necessary information. > But on the controller, it just gives me information on the category. > > I even do $ this-> Category-> recursive = 2; > > > > > Thank you in advance > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
