Codeigniter active record update with join
Try this one:
$this->db->set('votes', 'votes - 1', FALSE)$this->db->where('table1.user_id',$id);$this->db->where('table2.poll_id',$row);$this->db->update('table1 join table2 ON table1.poll_id= table2.poll_id');
try this out. It worked for me!!!
$data = array( 'a.ED_FName' => $_POST['firstname'], 'a.ED_MName' => $_POST['middlename'], 'a.ED_LName' => $_POST['lastname'], 'a.ED_Location' => $_POST['location'], 'a.ED_Company' => $_POST['company'], 'b.EMD_Department' => $_POST['department']);$this->db->set($data);$this->db->where('a.EmpID', $empID);$this->db->where('b.EmpID', $empID);$this->db->update('tbl_employeedetails as a, tbl_employeementdetails as b');Best Regards,TUSHAR NIRAS
Update:
Note: Never Use Global Arrays Like $_POST, $_GET Containing User's Request Data Directly Without Security Checks. This Can Lead to Serious Issues Like SQL Injections.