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? Link to comment https://forums.phpfreaks.com/topic/228399-not-updating/ 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); Link to comment https://forums.phpfreaks.com/topic/228399-not-updating/#findComment-1177689 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()"; Link to comment https://forums.phpfreaks.com/topic/228399-not-updating/#findComment-1177693 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. Link to comment https://forums.phpfreaks.com/topic/228399-not-updating/#findComment-1177707 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.