i have three tables
1. Rates: [id, Price, CourseID, others...]
2. Course: [id, noofpoints, GCources_id, others....]
3. GCourcess: [id, WeekIncFriday, Type, others........]
i mapped relationship between them [Rates -> Cources -> Gcources] , now i
want to get data from Rates and apply condition on GCources
My Query is
$this->Rate->Behaviors->attach('Containable');
$Rate = $this->Rate->find(
'first', array(
'conditions' => array(
'Rate.CourseID' => $courses_array
),
'contain' => array(
'Course' => array(
'GCourcess' => array(
'conditions' => array(
'GCourcess.WeekIncFriday' => 1
)
)
)
)
)
);
This generate error "Column not found: 1054 Unknown column
'GCourcess.WeekIncFriday' in 'where clause'"
**My quastion how can i apply this condition GCourcess.WeekIncFriday = 1
from Rates table?**
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
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].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
