Updating Multiple Rows in One Table...

[eluser]tonanbarbarian[/eluser]
I have never had any issues using $this->db->escape. Which database are you connecting to?

as for the first method if you want to do it safely try

Code:

foreach(array_keys($_POST) as $key) {
      $val = $this->input->post($key, true);
      $this->db->where('variable', $key);
      $this->db->update('settings', $val);
      }

so all we are doing here is looking at the keys in the POST and using the keys with the $this->input-post and forcing XSS_CLEAN on each post variable.