note 96763 added to function.date

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(); ---- Server IP: 219.94.145.73 Probable Submitter: 114.48.202.147 ---- Manual Page -- http://www.php.net/manual/en/function.date.php Edit -- https://master.php.net/note/edit/96763 Del: integrated -- https://master.php.net/note/delete/96763/integrated Del: useless -- https://master.php.net/note/delete/96763/useless Del: bad code -- https://master.php.net/note/delete/96763/bad+code Del: spam -- https://master.php.net/note/delete/96763/spam Del: non-english -- https://master.php.net/note/delete/96763/non-english Del: in docs -- https://master.php.net/note/delete/96763/in+docs Del: other reasons-- https://master.php.net/note/delete/96763 Reject -- https://master.php.net/note/reject/96763 Search -- https://master.php.net/manage/user-notes.php