Timestamps
| From: | Jason Pruim | Date: | Wed, 30 Apr 2008 15:29:24 +0000 |
| Subject: | Timestamps | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44932@lists.php.net to get a copy of this message | ||
Okay... So I know this should be simple...
Trying to store a timestamp in a MySQL database... The timestamp I am making like so: $modifiedTimestamp = time();
and then just $sql = "Update
mytable set timestamp='$modifiedTimestamp' where Record='1'";
Simple right? Not quite...in my database it's storing a "0" in the timestamp field which is a int(10) field.
I have googled, and searched manuals, but have not been able to figure out what is going on....
Any Ideas?
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
japruim@raoset.com