Jump to content

Not Updating


Kush

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.