from wich controller are you fetching data? users or details?
PS: i suggest you to follow cake's db conventions On 19 Gen, 06:33, John <[email protected]> wrote: > Hello > I have two tables that is users and details. i want to fetch data from > these 2 . i am getting details.id through which i have the whole row. > and in this row i have details.user_id and through this user_id i want > the row from users table. > > SELECT d.*,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 > > this is the simple query i want to make it through cake pattern but > find anything yet > > 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
