Limit 1 update in the code uses active record

Question

I am trying to update one record with the active codeigniter record and it still fails.

$data = array('status' => 1);

$this->db->where('field1', $info);
$this->db->update('example', $data);
$this->db->limit(1);

When I start updating all database fields. Doing $ this-> db-> last_query () won't show me the limit

What is a mistake?

+5

Alexd2 Aug 23 '12 at 7:29

1 answer

Yan berk · Accepted Answer · 2012-08-23T07:30:05+0000

Move the limit before the update, which should always be called last:

$this->db->limit(1);
$this->db->update('example', $data);