I second Jon's suggestion. Most straightforward.
On Oct 22, 8:29 am, "Jon Bennett" <[EMAIL PROTECTED]> wrote:
> > I've been looking for a while but I can't seem to find the solution.
>
> > Basically, I have Countries, which has many States, every State has
> > many Cities, and every City has many Users.
> > I'm trying to get all the Users in a specified State, and I don't want
> > to put a state_id in the user table, because it's relative to the city
> > hes.
>
> I would do this with 2 queries. First, get the IDs of all the cities
> in the state, then get all the users that belong to those Cities, eg:
>
> $cities = $this->User->City->generateList(array('City.state_id'=>$state_id));
>
> $users = $this->User->findAll(array('User.city_id'=>$cities));
>
> hth
>
> jon
>
> --
>
> jon bennett
> w:http://www.jben.net/
> iChat (AIM): jbendotnet Skype: jon-bennett
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
