Because your User table has no such column. Try running the find on the associated model.
$this->User->UserUsers->find(...) On Wed, Jul 4, 2012 at 2:38 PM, JonStark <[email protected]> wrote: > Hi everyone ! > > I have a question that shouldn't be that hard but I really can't manage it : > > In my app, User HABTM User > > users_users table is : id, following_id, follower_id > > I want to count every user where follower id is $id. > > This is my function : > >> public function countFollowing($id) { >> $user = $this->User->find('all', array( >> 'conditions' => array( >> 'UserUsers.follower_id' => $id >> ), >> )); >> count($user); >> } > > > But it returns Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column > 'UserUsers.follower_id' in 'where clause'... > > Any idea why ? Thanks a lot for your time ! > > -- > 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
