Hi, i have 3 tables Users, Improvements and Bookmarks a user can bookmark one or more improvements. The bookmark table holds the user_id and improvement_id. When i'm pulling the information (query below), i also need to show the author of the improvements username.
Is it possible to call a function in afterFind of the appropriate model which will retrieve the username for each improvement record e.g. function getUsername($user_id){ $conditions = array( 'conditions' => array('User.user_id' => $user_id), 'fields' => array('User.id', 'User.username'), 'order' => null, 'recursive' => -1, 'limit' => 1 ); return $this->set('post_author', $this->User->find('first', $conditions)); } SELECT `Bookmark`.`id`, `Bookmark`.`user_id`, `Bookmark`.`improvement_id`, `User`.`id`, `User`.`username`, `Improvement`.`id`, `Improvement`.`user_id`, `Improvement`.`title`, `Improvement`.`description`, `Improvement`.`created` FROM `bookmarks` AS `Bookmark` LEFT JOIN `users` AS `User` ON (`Bookmark`.`user_id` = `User`.`id`) LEFT JOIN `improvements` AS `Improvement` ON (`Bookmark`.`improvement_id` = `Improvement`.`id`) WHERE `Bookmark`.`user_id` = 12 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---