jholcomb Posted November 11, 2011 Share Posted November 11, 2011 Hi, I have a problem in which I have 3 tables (PotentialLoans, SalesPeople, Dealers) the relationships are as follows. PotentialLoans belongsTo SalesPeople SalesPeople belongsTo Dealers the code I got to work I believe is probably not the best practice for cakePHP the code that works follows public function reply($id = null) { $this->PotentialLoan->id = $id; if (!$this->PotentialLoan->exists()) { throw new NotFoundException(__('Invalid potential loan')); } $this->set('potentialLoan', $this->PotentialLoan->read(null, $id)); $this->set('dealer', $this->PotentialLoan->query("SELECT d.id, d.name, d.address, d.city, d.state, d.zip, d.phone, d.fax FROM potential_loans p, sales_people s, dealers d WHERE p.sales_person_id = s.id AND s.dealer_id = d.id AND p.id =" . $id)); } Any help in cleaning this up would be appreciated. Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/250933-data-from-3-tables-2-of-which-are-related-only-through-the-third/ Share on other sites More sharing options...
jcombs_31 Posted November 13, 2011 Share Posted November 13, 2011 What exactly is your question? What exactly are you trying to accomplish? What controller are you using? Why are you using "query" instead of "find"? Quote Link to comment https://forums.phpfreaks.com/topic/250933-data-from-3-tables-2-of-which-are-related-only-through-the-third/#findComment-1287856 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.