chris chris - 2 months ago 21
MySQL Question

CodeIgniter single update query to update one column with an existing columns data?

In my db I have a Last and a Current column for datetime. Just to keep an eye on when someone last used a valid login to the service I am building up.

What I want to know is, is it possible to update one column on a row with another column from that row, while updating the other column at the same time

Ie: Set the Last as the current Current, then set the Current with the date thats right now essentially?

Make any sense?

Answer

Try like this ..

$data=array('last_login'=>current_login,'current_login'=>date('Y-m-d H:i:s'));
$this->db->where('id','some_id');
$this->db->update('login_table',$data);