Hello. I Have two models,Brands and Products, where Brand hasmany Products When I calling action 'view' in my products controller, I need following result , .
SELECT `Brand`.`id`, `Brand`.`active`, `Brand`.`name`, `Brand`.`description`, `Brand`.`image`, `Brand`.`website`, `Brand`.`created`, `Brand`.`modified` FROM `brands` AS `Brand` WHERE `Brand`.`id` = 10 LIMIT 1 SELECT `Product`.`id`, `Product`.`active`, `Product`.`brand_id`, `Product`.`name`, `Product`.`created`, `Product`.`modified` FROM `products` AS `Product` WHERE active = 1 AND `Product`.`brand_id` = (10) ORDER BY `created` DESC LIMIT 9 How can do with read() or findById() ??? -- 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
