Hi Amit, thank you for your help. But it didn't work. I may, as well post the whole function here. This is a favorites section that I'm trying to create. All I'm trying to do,... is call parent_id so I can link it to original video user username(profile) and video from view page favorites.ctp. If you have a time can you please take peak at
http://www.zippopeople.com and this is a testing URL Thank Yo..All ! function favorites($username = null) { if($username == 'unknown') $this->authorize(); if(!($user = $this->User->findByUsername($username))) { $this->flash('error', ucfirst(i18n::translate('user not found'))); $this->redirect('/'); } else { $filter = $this->params['pass']; unset($filter['page']); unset($filter['sort']); unset($filter['direction']); $this->set('url_options', $filter); $parent_id = $this->Video->field('user_id'); $this->menu->setSelected('/videos/index/' . $user['User'] ['username']); $this- >set_title(ucfirst(Inflector::pluralize(i18n::translate('favorite videos'))) . ' : ' . $user['User']['firstname'] . ' ' . $user['User'] ['lastname']); $scope = array('VideoFavorite.user_id' => $user['User']['id']); if(array_key_exists('date', $this->params['pass'])) $scope[] = 'DATE(VideoFavorite.created) = \'' . strftime('%Y- %m-%d', strtotime($this->params['pass']['date'])) . '\''; if($this->is_user()) $is_friend = in_array($this->user['id'], $this->Friend- >myFriends($user['User']['id'])); else $is_friend = false; if($this->is_user() && $this->user['id'] == $user['User']['id']) { // the owner has no restriction } elseif($this->is_user() && $is_friend) { $scope[] = 'VideoFavorite.privacy <= ' . array_search('friend', Configure::read('Site.privacy')); } else { $scope[] = 'VideoFavorite.privacy <= ' . array_search('public', Configure::read('Site.privacy')); } $videos = $this->paginate('VideoFavorite', $scope); $this->set('videos', $videos); $this->set('dates', $dates = $this->VideoFavorite->query('SELECT DATE(created) AS date, COUNT(*) AS videos FROM fociki_video_favorites WHERE user_id = ' . $user['User']['id'] . ' GROUP BY DATE(created) ORDER BY created DESC')); $videos_count = 0; foreach($dates as $date) $videos_count += $date[0]['videos']; $this->set('videos_count', $videos_count); $this->set('user_obj', $user); $this->set('parent', $parent_id); $this->set('friends', $this->Friend->find('all', array('limit' => 12, 'conditions' => array('Friend.user_id' => $user['User']['id']), 'order' => array('Friend.created' => 'DESC')))); } } and here is my tables: videos table id int(11) UNSIGNED No auto_increment user_id int(11) Yes NULL category_id int(11) Yes NULL name varchar(120) latin1_swedish_ci No description text latin1_swedish_ci Yes NULL embed_code text latin1_swedish_ci Yes NULL video_thumb text latin1_swedish_ci Yes NULL views int(11) No 0 comments int(11) No 0 last_comment datetime Yes NULL promo_status int(11) No 0 privacy int(1) UNSIGNED No 0 created datetime No 0000-00-00 00:00:00 video_favorites table id int(11) UNSIGNED No auto_increment video_id int(11) UNSIGNED No 0 user_id int(11) Yes NULL category_id int(11) Yes NULL privacy int(1) UNSIGNED No 0 created datetime No 0000-00-00 00:00:00 parent_id int(11) Yes NULL Thanks again, any help is appreciated !!! Chris On Dec 22, 4:20 pm, Amit Rawat <[email protected]> wrote: > Hi Chris, > > Use find field > > $parent_id = $this->Video->field('user_id',array('your condition goes > here')) > > enjoy, > > Amit > > On Thu, Dec 23, 2010 at 3:41 AM, [email protected] <[email protected]>wrote: > > > > > > > > > Hi All,... sound stupid but I have to ask... > > I want to call user_id from Video table in to $parent_id variable in > > my controller in order to display and link to parent user username, > > video in ..."Favorites" section. And how do I do that...? Please > > help... > > > $parent_id = $this->Video ??? > > > thanks > > > Check out the new CakePHP Questions sitehttp://cakeqs.organd help others > > with their CakePHP related questions. > > > You received this message because you are subscribed to the Google Groups > > "CakePHP" group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected]<cake-php%[email protected] > > om>For more options, visit this group at > >http://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
