Never mind ... got it :)
function index() {
$this->User->recursive = 0;
$this->set('users', $this->paginate());
$username = $this->Session->read('user');
if ($username) {
$results = $this->User->findByEmail($username);
$this->set('user', $results['User']);
// get their profiles
$user_id = $results['User']['id'];
$profiles =
$this->User->Profile->findAll('profile.user_id='.
$user_id, array('fields' => '*'));
$this->set('profile', $profiles);
} else {
$this->redirect(array('action' => 'login'), null, true);
}
}
On Jul 20, 12:33 pm, Mr K <[EMAIL PROTECTED]> wrote:
> hey there
>
> I have two tables in my database, Users & Profiles - (profiles btw are
> the sites a user belongs to). A user can have many profiles
>
> So in my users controller I have this:
> function index() {
> $this->User->recursive = 0;
> $this->set('users', $this->paginate());
>
> $username = $this->Session->read('user');
>
> if ($username) {
> $results = $this->User->findByEmail($username);
> $this->set('user', $results['User']);
> // get their profiles
> $user_id = $results['User']['id'];
> $results =
> $this->User->Profile->findAll('profile.user_id='.
> $user_id, array('fields' => '*'));
> $this->User->Profile->set('profile',
> $results['Profile']);
> } else {
> $this->redirect(array('action' => 'login'), null, true);
> }
> }
>
> What I'm trying to do is get a list of all profiles for this user.
> The code above works, and $results =
> $this->User->Profile->findAll('profile.user_id='.$user_id, array('fields' =>
> '*')); does
>
> return all the profiles for the given user
>
> Now I want to set this into the user object ... but I can't seem to do
> this.
> I've now got a page where I get the username etc (their personal page)
> and I simply want to say
>
> Hi, Bob
>
> Your Profiles:
> * This Site
> * That Site
> * A Site
>
> I can't seem to get the information out of my user controller to my
> index.ctp
>
> Thanks
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
