• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to update joined tables

#1
I've been searching for an answer to this, but evidently the working solution for v2 doesn't work in v3.

Code:
$this->db->set('a.firstname', 'Pekka');
$this->db->set('a.lastname', 'Kuronen');
$this->db->set('b.companyname', 'Suomi Oy');
$this->db->set('b.companyaddress', 'Mannerheimtie 123, Helsinki Suomi');

$this->db->where('a.id', 1);
$this->db->where('a.id = b.id');
$this->db->update('table as a, table2 as b');

That code came from here - http://tinyurl.com/jjarn8r

Does anyone have a working solution please?

Yours Roy
Bee Creative Web Design
www.bcwd.ltd.uk
Reply

#2
I didn't event know you could make an update on joined tables. What is the advantage over 2 simple updates?
CodeIgniter 4 tutorials (EN/FR) - https://includebeer.com
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.