I might need to see your models but you probably need to do something like
this.
$this->Business->find('all,array('conditions'=>array('Business.city'=>$city)
,'contain'=>array('Category')));
The contain clause will make sure to limit your search results to have only
categories (as well as the businesses) in the results.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf
Of vcrack
Sent: Wednesday, March 17, 2010 10:23 PM
To: CakePHP
Subject: help me about association query
my code
I have model Business and model category. i want to find business for
all category but from X city..
$this->Business->Category->find('all', array('conditions' =>
array('Business.city' => $city)));
error message : SQL Error: 1054: Unknown column 'Business.city' in
'where clause'
I'm sure in column city in table model business is exist.. anyone can
help mer?
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
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
