Sorry, the example is not appropriate. How about this? Tag table: id | name
Task table: id | user_id | name I want get all the tasks of a tag. On Thu, Apr 2, 2009 at 12:31 AM, francky06l <[email protected]> wrote: > > Looking at your user/task description Isn'it a simple User hasMany > Task ? In such case, containable can do the job .. > unless I am missing something > > On Apr 1, 2:58 pm, joshua <[email protected]> wrote: > > Yes, we can use containable to get the task's users. But if there is a > user > > , I want to find all the tasks he owns. How can I do? > > > > User table: > > id | name > > > > Task table: > > id | user_id | name > > > > We can't count on containable to help us to find the relate tasks. And I > > count on 'join' to help me to do this. Any suggestions? > > > > > > > > On Wed, Apr 1, 2009 at 2:09 AM, Amit <[email protected]> wrote: > > > > > I highly recommend checking out the Containable behavior: > > > > >http://book.cakephp.org/view/474/Containable > > > > > It will simplify this code and let you easily add fields. > > > > > On Mar 31, 8:28 am, joshua <[email protected]> wrote: > > > > For example: > > > > One task has many users. > > > > ######################## > > > > $condition = array(); > > > > $condition['joins'] = array( > > > > array( > > > > 'table' => 'users', > > > > 'alias' => 'User', > > > > 'type' => 'inner', > > > > 'foreignKey' => 'user_id', > > > > 'conditions'=> array('User.id = > > > > Task.user_id','User.deleted=0') > > > > )); > > > > ######################## > > > > I just want to find the user name , not all the fields in User table. > I > > > try > > > > to add the 'fields' property in this array, but it seems not. > > > > -- > > > > Thanks > > > > Joshua > > > > -- > > Thanks > > Joshua > > > -- Thanks Joshua --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
