Updating data on another DB - is that possible?

[eluser]Karman de Lange[/eluser]
[quote author="red2034" date="1392487397"]So now that I have access to multiple DBs (default, platform) this is what I would like to do:

Code:

public function index()
    {
  $course_id = '18896';
        if ($this->session->userdata('student_login') != 1)
            redirect(base_url() . 'index.php?login', 'refresh');
        if ($this->session->userdata('student_login') == 1)
$this->db_platform = $this->CI->load->database('platform', TRUE);  
$class_status = $this->db_platform->get_where('class' , array('status' => 'not attempted'))->row_array();
     $data['status'] = 'in-progress';
            
            $this->db_platform->update('status', $data);
   redirect(base_url() . 'index.php?student/dashboard', 'refresh');
  
    }

I am trying to change the 'status' data to 'in-progress' but it is not updating...

Anybody see my error?[/quote]

This $this->db_platform->update('status', $data); will update all rows your status table to 'in-progress' , you need a where clause to limit it to 1 row (if that is the intention).

Are you getting any errors or what is the issue?

L: