Re: Code Help

I would get all users who *are* following and then look up everyone except them.

$followers = $this->User->Follow->find('all', array(

'conditions' => array(

  'Follow.followed_by' => $this->Auth->user('id')

)

));

$nonfollowers = $this->User->find('all', array(

'conditions' => array(

  'not' => array(

    'User.id' => Set::extract('/Follow/followed_to', $followers)

  )

)

));

On Sunday, March 4, 2012 11:02:17 PM UTC-8, Wasif wrote:

Hi all,

I am writing a function and i would like to call all the site users
who are not being followed by the session user.

I am stuck here since 2 days, could anyone help me here?

function people() {
$options=array(
        
'fields'=>array('User.id','User.fname','User.lname','User.f_id','Follow.followed_by','Follow.followed_to'),
                                           'joins'=>array(array('table'=>'follows',
                                                                                        'alias'=>'Follow',
                                                                                        'type'=>'left',
                                                                                        'conditions'=>array('Follow.followed_by!='.$this->Session-
>read('Auth.User.id'),'Follow.followed_to=User.id'))),
                                           'group'=>'User.id',
                                           'conditions'=>array('User.f_id'=>1),
                                           );
                $this->set('users',$this->User->find('all',$options));
}

--
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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php