note 96763 deleted from function.date by danbrown
| From: | danbrown@php.net | Date: | Mon, 15 Mar 2010 16:19:29 +0000 |
| Subject: | note 96763 deleted from function.date by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-167036@lists.php.net to get a copy of this message | ||
Note Submitter: amigojapan
----
you need to make a timestamp in the following way to update a mysql timestamp, it must be in single
quotes:
$mysqltimestamp= "'". date('Y-m-d H:i:s') ."'";
echo $mysqltimestamp;
$stmt = $mysqli->prepare("UPDATE ads.desktopads SET
latestviewtimestamp=$mysqltimestamp;");
$stmt->execute();
$stmt->close();