Change the status in the db

Hello, 



I am a beginner with Codeigniter.
I want to change the status of my comments in order to validate them.
Let me explain: by default comments have a value of 0 and invisible to visitors.
I created an administrator space to manage comments.

I want to change the status from 0 to 1 simply.

I tried this: 

PHP Code:

$ this-> db-> where ('comment_id', $ comment_id);

$ This-> db-> update ('status', '1');
$ This-> save (); 


I have a mistake:

Error Number: 1064

Syntax error near '1 =' 'WHERE `id_commentaire` =' 24 '' in line 1

UPDATE `status` SET 1 = '' WHERE` id_commentaire` = '24'

Filename: C: /wamp64/www/codeIgniter2/system/database/DB_driver.php

Line Number: 691

Thank you in advance for your answers

See you soon

Hello, 



I am a beginner with Codeigniter.
I want to change the status of my comments in order to validate them.
Let me explain: by default comments have a value of 0 and invisible to visitors.
I created an administrator space to manage comments.

I want to change the status from 0 to 1 simply.

I tried this: 

PHP Code:

$ this-> db-> where ('comment_id', $ comment_id);

$ This-> db-> update ('status', '1');
$ This-> save (); 


I have a mistake:

Error Number: 1064

Syntax error near '1 =' 'WHERE `id_commentaire` =' 24 '' in line 1

UPDATE `status` SET 1 = '' WHERE` id_commentaire` = '24'

Filename: C: /wamp64/www/codeIgniter2/system/database/DB_driver.php

Line Number: 691

Thank you in advance for your answers

See you soon

update to 3

PHP Code:

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

$this->db->where('comment_id', $comment_id);
$this->db->update('mytable', $data); 


A big thank-you. It was so simple, I'm ashamed ...