My User Model :
class User extends AppModel {
> public $name = 'User';
>
> public $hasAndBelongsToMany = array(
> 'Following' => array(
> 'className' => 'User',
> 'joinTable' => 'users_users',
> 'foreignKey' => 'follower_id',
> 'associationForeignKey' => 'following_id',
> 'unique' => true,
> 'conditions' => '',
> 'fields' => '',
> 'order' => 'Following.username ASC',
> 'limit' => '',
> 'offset' => '',
> 'finderQuery' => '',
> 'deleteQuery' => '',
> 'insertQuery' => ''
> ),
> 'Follower' => array(
> 'className' => 'User',
> 'joinTable' => 'users_users',
> 'foreignKey' => 'following_id',
> 'associationForeignKey' => 'follower_id',
> 'unique' => true,
> 'conditions' => '',
> 'fields' => '',
> 'order' => 'Follower.username ASC',
> 'limit' => '',
> 'offset' => '',
> 'finderQuery' => '',
> 'deleteQuery' => '',
> 'insertQuery' => ''
> )
> );
>
>
> }
The table used for association is users_users , wich has id, follower_id
and following_id
Le mercredi 4 juillet 2012 20:38:05 UTC+2, JonStark a écrit :
>
> 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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
