hi, just few days ago i found out about this miracle called cakePHP so i am pretty green to it. i need to build a mail application, so i have followed the convention and created:
data base description: table of users <user_id (primary key), fname, lname>. table of mails <mail_id(primary key), from (foreign key to user_id), to (foreign key to user_id), content, opened> my questions: 1) according to the convention, a foreign key should be called related table+'_id'. how should i call the columns if there are two foreign keys that relate to the same table. like from and to in the mails table. 2) i would like to do an inner JOIN the between the two table. something like SELECT user_id, mail_id FROM users INNER JOIN mails ON users.user_id =mails.to AND mails.opened=false. but i have no clue how to do it. please advise, thanks Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" 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
