Oh thank you! The association solved it!
On Apr 9, 6:37 pm, "soytuny" <[EMAIL PROTECTED]> wrote:
> In a project I'm working on, I have a messages table as well. In the
> message.php I have the following association
>
> var $belongsTo = array(
> 'Recipient' =>
> array('className' => 'User',
> 'foreignKey' => 'recipient_id',
> ),
>
> 'Sender' =>
> array('className' => 'User',
> 'foreignKey' => 'sender_id',
> ),
> );
>
> The className is User for both, but the instances of the class have
> unique names, ie Recipient and Sender.
>
> Now if you want to get all the messages sent by user id 2:
>
> $sentBy2 = $this->Message->findAll(array('Sender.id' => 2)); //didn't
> test this
>
> Hope that helps,
> Russell
>
> On Apr 9, 8:41 am, "erdbeerelse" <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > hello,
>
> > I have a question about naming convention with foreign keys. in my
> > first table (users) I have a primary key id, which is the user id
> > followed by username, useradress.... in my second table (msgs) I save
> > messages from a user to a user. So I want to reference the foreigns
> > keys fromuser and touser to the table users and the field id.
>
> > the conventions say, that the foreign key in my table msgs should be
> > user_id (=table_fieldname). My problem is, that I need this foreign
> > key twice just like:
>
> > from_user_id and to_user_id
>
> > Could anyboldy please help me to figure it out? Thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [EMAIL PROTECTED]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
