move data from one column to another mysql

Question

I am wanting to move data from one column to another in a MySQL table.

Here is my code:

   $sDate = date("d-m-Y H:i:s");

mysql_query( "   UPDATE users
SET 
  logintimelast = logintime 

AND 
  logintime = '$sDate'");

However this does not update either column?

Explosion Pills · Accepted Answer · 2013-12-11 21:19:07Z

4

Because your syntax is wrong. lotintime AND logintime = '$sDate' is a boolean expression.

SET
    logintimelast = logintime,
    logintime = '$sDate'

Your query is vulnerable to injection. You should stop using ext/mysql and use properly parameterized queries with PDO or mysqli

answered Dec 11, 2013 at 21:19

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

And you (OP) should add error reporting, which would've told you about the invalid SQL.