Not Updating

[Kush]

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?

[Veteah]

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);

[BlueSkyIS]

^ i wouldn't do that. date/time fields should be date/time fields.

 

$sql = "UPDATE table_name SET *your_fields_here*, `timestamp` = NOW()";

[Kush]

^ i wouldn't do that. date/time fields should be date/time fields.

 

$sql = "UPDATE table_name SET *your_fields_here*, `timestamp` = NOW()";

 

Thanks.