Kush Posted February 21, 2011 Share Posted February 21, 2011 Hi, I'm using php to access the mysql database using mysqli and I have a field on my table called "timestamp" and it's set as a timestamp and has current_time (I think in phpmyadmin it was a tick option so I clicked it) and when I update that row in my table the field "timestamp" doesn't update with the timestamp from when it was last updated/modified. I thought the field option timestamp automatically did that? I'm guessing not.. is there a way I can update the timestamp with the current time in my query? Quote Link to comment Share on other sites More sharing options...
Veteah Posted February 21, 2011 Share Posted February 21, 2011 Yep, although to be honest it's simpler (at least I think so) to change the timestamp to a simple int field. From there, everytime you make an update query or insert a new value add put in something like: $sql = "UPDATE table_name SET *your_fields_here*, date = ". strtotime('now'); $run = mysqli_query($sql); Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted February 21, 2011 Share Posted February 21, 2011 ^ i wouldn't do that. date/time fields should be date/time fields. $sql = "UPDATE table_name SET *your_fields_here*, `timestamp` = NOW()"; Quote Link to comment Share on other sites More sharing options...
Kush Posted February 21, 2011 Author Share Posted February 21, 2011 ^ i wouldn't do that. date/time fields should be date/time fields. $sql = "UPDATE table_name SET *your_fields_here*, `timestamp` = NOW()"; Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.