On Jun 7, 9:26 am, Lemune <[EMAIL PROTECTED]> wrote:
> This time about using query.
> In my application i use some table like
> companies,login,administrators,sales_people. In login, there are 5
> fields, id, username,password,login_type_id,user_id.
> login_type_id is going to tell witch table are, and user_id is id of
> the user on appropriate table.
> So basically in table logins field login_type_id and user_id will be
> unique.
> But when I'm trying to make CRUD, i got problem.
> I want to use query like this : "SELECT
> s.id,s.name,s.birtday,s.address,s.phone,s.mobile,s.email,s.target,
> l.username,l.password FROM sales_people_table s, logins_table l WHERE
> s.id=l.user_id AND l.login_type_id=2" (for sales person).
> I want in my view to view them all.
> Could some one help me on this.
Don't use query and use findAll on your Login model (assuming login
belongsTo user.). Query is there for when you need to do something
above and beyond the scope of the existing cake db methods - not as a
poor substitute for them ;).
hth,
AD
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
