开发者

UPDATE table SET time = NOW() not working

开发者 https://www.devze.com 2023-02-13 21:43 出处:网络
I\'m very confused here, this is like lesson 1 mysql top开发者_JS百科ic, but.. $update = mysql_query(\"UPDATE usuarios SET lastactivity = NOW() WHERE id = \'$id\'\") or die(mysql_error());

I'm very confused here, this is like lesson 1 mysql top开发者_JS百科ic, but..

  $update = mysql_query("UPDATE usuarios SET lastactivity = NOW() WHERE id = '$id'") or die(mysql_error());

Why does this not update lastactivity from usuarios to current_timestamp?

lastactivity   timestamp           No  CURRENT_TIMESTAMP   
0

精彩评论

暂无评论...
验证码 换一张
取 消