Sunday, 8 September 2013

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

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?

No comments:

Post a Comment