http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html look for hasMany association :) -- Lep pozdrav, Tilen Majerle http://majerle.eu
2011/12/1 Tilen Majerle <tilen.maje...@gmail.com> > do you have associations created ? > > you should have something like that > > Class hasMany Period > Class hasMany Post > Period hasMany Post (add here assocation key "dependent" => true) //so > this will delete all posts for given period_id when you delete some period > where Post.period_id = Period.id > > Period belongsTo Class > Post belongsTo Class > Post belongsTo Period > > am i right ? :) > > I hope you understand :) > > -- > Lep pozdrav, Tilen Majerle > http://majerle.eu > > > > 2011/12/1 GG <jairusk...@gmail.com> > >> Right now, my PeriodsController.php delete() function, deletes entries >> in my periods table. (Not a problem). >> My PostsController.php delete() function, deletes entries in my posts >> table. (Also not a problem.) >> (The problem) = I would like my PeriodsController.php delete(), to >> also delete any posts (in my posts table), where they have a matching >> period_id. >> >> >> ///Example: I am a teacher who has a science class. I post homework >> under my science period. When I want go to delete the science class >> period, I would like it to also delete all of the posts I made under >> that class period... >> >> >> So...... >> >> I have a periods table: >> >> period_id | title | user_id >> >> >> >> I also have a posts table: >> >> id | title | body | created | modified | user_id | period_id >> >> >> >> Here is my PeriodsController.php >> >> function delete($id) { >> if (!$this->request->is('post')) { >> throw new MethodNotAllowedException(); >> } >> >> if($this->isActionable($id)){ >> if ($this->Period->delete($id)) { >> $this->Session->setFlash('Class successfully deleted.'); >> $this->redirect(array('controller' => 'posts', 'action' => >> 'index')); >> } >> } else { >> $this->Session->setFlash('You cannot delete that >> class.'); >> $this->redirect(array('controller' => 'posts', >> 'action' => >> 'index')); >> } >> } >> >> >> Here is my PostsController.php >> >> function delete($id) { >> if (!$this->request->is('post')) { >> throw new MethodNotAllowedException(); >> } >> >> if($this->isActionable($id)){ >> if ($this->Post->delete($id)) { >> $this->Session->setFlash('Post successfully deleted.'); >> $this->redirect(array('action' => 'index')); >> } >> } else { >> $this->Session->setFlash('You cannot delete that >> post.'); >> $this->redirect(array('action' => 'index')); >> } >> } >> >> >> >> Any help is greatly appreciated. Thanks! >> >> -- >> Our newest site for the community: CakePHP Video Tutorials >> http://tv.cakephp.org >> Check out the new CakePHP Questions site http://ask.cakephp.org and help >> others with their CakePHP related questions. >> >> >> To unsubscribe from this group, send email to >> cake-php+unsubscr...@googlegroups.com For more options, visit this group >> at http://groups.google.com/group/cake-php >> > > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php