I did try your code but it's return all data business and related data
business..
I want to find all category and in array category contain all related
business but have X city..
my model..
models/business.php
class Business extends AppModel{
var $name = 'Business';
var $belongsTo = array('Category','BusinessContact','Mall');
var $hasAndBelongsToMany = array(
'User' =>
array(
'className' => 'User',
'joinTable' =>
'favorites',
'foreignKey' =>
'business_id',
'associationForeignKey' =>
'user_id'
)
);
}
models/category.php
class Category extends AppModel{
var $name = 'Category';
var $hasMany = array('Business');
}
i still need your help.. thanks, :)
On Mar 18, 1:14 pm, "Alan Asher" <[email protected]> wrote:
> 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 sitehttp://cakeqs.organd help others
> with their CakePHP related questions.
>
> You received this message because you are subscribed to theGoogleGroups
> "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
> athttp://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
