Member Avatar for mangel.murti

hi ,
i want to delete records form these tablesw i have pk fk relationshilp with addcampid on all tables. master table is add_campaign...
i am using CI.

mytable are

add_campaign cac,
add_subscriber cas
calender cc,
calender_master ccm,
task cc,
task_master ctm,
triggers_actions cta,
triggers_email cte,
jqcalendar jq,
manage_action cma

any help aprr.
thnx

  • 2 Contributors
  • 1 Reply
  • 117 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for cereal

Check the guide: http://codeigniter.com/user_guide/database/active_record.html#delete

$this->load->library('database');

$this->db->where('id',$id);
$this->db->delete('add_campaign');

$tables = array('table1', 'table2', 'table3');
$this->db->where('addcampid', $id);
$this->db->delete($tables);

bye

Edited by cereal because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.