I assume that you have defined the following associations/
relationships in your models:
Detail belongsTo User / User hasMany Details
If you have the Detail record, then you can make the following query
from the Detail controller side:
[code]
$this->Detail->User->find(
'all', array(
'recursive' => 1,
'conditions' => array(
'User.id' => $this->data['Detail']['user_id']
)
)
);
[/code]
Enjoy,
John
On Jan 13, 9:51 am, Manu <[email protected]> wrote:
> I have two tables details and users . I am getting the Detail.id from
> this i will be able to know User.id and then from users table i have
> to fetch user data like(name, email, etc). so i want to make query in
> cake pattern that in result should give me data of both the table.
> Here's simple query that i have made but couldnt get it going in cake
> pattern.
>
> SELECT d.vps_name, d.machine_type, d.ipAddress, d.rdp_user,d.rdp_pass,
> d.dc_user, d.dc_pass, d.status, d.user_id, d.order_id,u.email,
> u.fname, u.lname FROM details as d
> LEFT JOIN users as u
> ON d.user_id = u.id
> WHERE d.user_id = u.id
>
> Thanks in advance
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
