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.
Thks.) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
