How to update MySql timestamp column to current timestamp on PHP?

Question

I want to update the columns of data type timestamp manually through my PHP code.

Can you please tell me how to do that?

question from:https://stackoverflow.com/questions/5869392/how-to-update-mysql-timestamp-column-to-current-timestamp-on-php

Answer 1

Use this query:

UPDATE `table` SET date_date=now();

---

Sample code can be:

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

mysql_query("UPDATE `table` SET date_date=now()");

mysql_close($con);
?>