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

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

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.