Problems w/ User having many friends
This seems so easy but I keep hitting a brick wall on this.
I have this modeling:
I have these 2 records in the friends table
class User < ActiveRecord::Base
has_many :friends, :through => :friendships #...
class Friendship < ActiveRecord::Base
belongs_to :friend, :class_name => 'User', :foreign_key => 'friend_id'
Now when I try to select all friends that belong to User of id 3, using this select I get one record instead of 2:
@users = User.find:all, :include=>[:friendships], :conditions=>["friendships.user_id=?",3])
Any ideas how I can model this and query this correctly to get both records belonging to User 3?
Thanks a whole lot!