• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Update issue (Query Builder Class)

#1
For some reason I'm getting extra back ticks in my update statement.

       $this->db->where('table2acct_id', $acct_id);
       $this->db->where('table1id', $id);
       $this->db->where('enabled', 1);
       $this->db->where('checkin_close_time >= UTC_TIMESTAMP()');
       $this->db->update("table1 JOIN table2 ON table1id= table2id JOIN table3 ON table2id=table3id", $update_data);

The issue is in the update statement. The query returns:
UPDATE `table1 JOIN table2 ON table1id= table2id JOIN table3 ON` `table2id=table3id` SET ...

For some reason there is an extra back tick between my last ON statement.

Thanks in advance.
Reply


Messages In This Thread
Update issue (Query Builder Class) - by ogomez - 07-05-2018, 05:59 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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