Relationship Confusion

Can someone help me out with this situation. Will try to explain as simple
as possible.

User A creates an ad => he selling a lawnmower (Ads)
User B views the ad belonging to User A and wants to click "Interested"
which will make a record in the DB table called "Interests"

I need the table to be accessed by both User A and User B for different
reason. User A will see who is interested in his offers, and User B will see
all the offers he is interested in.

But how do you define that relationship? cant be 2 user_id's in the table..
Interests Table:
id
seller_id => the ad owner user_id
buyer_id => the interested user_id

But the User to Interests relationship...how can you determine the keys for
this?

Thanks in advance for any help

Dave

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en
-~----------~----~----~----~------~----~------~--~---