How to Update Database field value +1
Use direct database Update instead of Model to increment a field +1
I always use the CodeIgniter models to do all the MySQL querys (insert, select, updates…) but this won’t work if you want to update a count field +1.
Use this direct code in your Controller Function:
$this->db->set('my_field', 'my_field+1', FALSE);
$this->db->where('my_other_field', 'test');
$this->db->update('my_table');
$this->db->where('my_other_field', 'test');
$this->db->update('my_table');
Related PostsIf you liked How to Update Database field value +1; the posts below might interest you too:
|
