mysql - less than or greater than in where clause in codeigniter model -


i want execute query

update `eventinfo` set `status` = '0' `eventdatetime`< `2015-05-12 01:17:23`. 

i tried in different ways this

$whereclause = 'eventdatetime'.'<'.$check_date; $this->db->where($whereclause); 

but failed.what correct way.

different way :

$data = array( 'status' => '0',  );  $this->db->where('eventdatetime <', '2015-05-12 01:17:23'); $this->db->update('eventinfo', $data); 

Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -