mysql codeigniter active record m:m deletion

Posted by sea_1987 on Stack Overflow See other posts from Stack Overflow or by sea_1987
Published on 2010-05-23T13:03:42Z Indexed on 2010/05/23 13:11 UTC
Read the original article Hit count: 146

Hi There,

I have a table 2 tables that have a m:m relationship, what I can wanting is that when I delete a row from one of the tables I want the row in the joining table to be deleted as well, my sql is as follow,

Table 1

    CREATE TABLE IF NOT EXISTS `job_feed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `body` text NOT NULL,
  `date_posted` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

Table 2

    CREATE TABLE IF NOT EXISTS `job_feed_has_employer_details` (
  `job_feed_id` int(11) NOT NULL,
  `employer_details_id` int(11) NOT NULL,
  PRIMARY KEY (`job_feed_id`,`employer_details_id`),
  KEY `fk_job_feed_has_employer_details_job_feed1` (`job_feed_id`),
  KEY `fk_job_feed_has_employer_details_employer_details1` (`employer_details_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

So what I am wanting to do is, if the a row is deleted from table1 and has an id of 1 I want the row in table to that also has that idea as part of the relationship also.

I want to do this in keeping with codeigniters active record class I currently have this,

public function deleteJobFeed($feed_id)
    {
        $this->db->where('id', $feed_id)
                 ->delete('job_feed');

        return $feed_id;
    }

© Stack Overflow or respective owner

Related posts about mysql

Related posts about activerecord