Jump to content

Please help inserting timestamp


lingo5

Recommended Posts

Hi, I have a MySQL table with a timestamp field. I want this field to be automatically updated with the current date and time when a record is updated.

How do I do that?

This is my update query. Thanks:

 

$Sql="UPDATE MyTable SET 
client_alias='$client_alias',testimonial_date='$testimonial_date',order_ontime='$order_ontime',how_deal='$how_deal',order_condition='$order_condition',happy_colour='$happy_colour',colour_chosen='$colur_chosen',easy_use='$easy_use',effectiveness='$effectiveness',client_comments_eng='$client_comments_eng',client_comments_esp='$client_comments_esp',testimonial_updated_by='$testimonial_updated_by', _time_stamp='?????????'  WHERE id_testimonial='$colname_testimonials_update_RS'";

mysql_query($Sql) or die('Error, query failed : ' . mysql_error()); 

Link to comment
https://forums.phpfreaks.com/topic/253025-please-help-inserting-timestamp/
Share on other sites

During update, timestamp field is updating automatically, therefore you can not worry :)

And modify your code a bit.

<?
$Sql="  UPDATE `MyTable` SET 
        `client_alias` = '" . $client_alias ."',  `testimonial_date` = '" . $testimonial_date . "',
        `order_ontime` = '" . $order_ontime . "', `how_deal` = '" . $how_deal . "', `order_condition` = '" . $order_condition . "',
        `happy_colour` = '" . $happy_colour . "', `colour_chosen` = '" . $colur_chosen . "', `easy_use` = '" . $easy_use . "',
        `effectiveness` = '" . $effectiveness . "', `client_comments_eng` = '" . $client_comments_eng . "', `client_comments_esp` = '" . $client_comments_esp . "',
        `testimonial_updated_by` = '" . $testimonial_updated_by . "'  WHERE `id_testimonial` = '" . $colname_testimonials_update_RS . "'";

mysql_query($Sql) or die('Error, query failed : ' . mysql_error()); 

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.