Re: [PHP-DB] Timestamps
[email protected] ("YVES SUCAET")
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
Hi Jason, It's not because you create a date/time value that you automatically have an integer-value. You need to specify first that you want the date/time value converted to an integer value first. See http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_unix-timestamp for an example of how to do this. Actually, by using this function, you probably don't even need to create the $modifiedTimestamp variable anymore. You can just write your SQL query as follows: $sql = "Update `mytable` set timestamp=UNIX_TIMESTAMP() where Record='1'"; HTH, Yves ------ Original Message ------ Received: Wed, 30 Apr 2008 10:39:11 AM CDT From: Jason Pruim <[email protected]> To: Stut <[email protected]>Cc: [email protected] Subject: Re: [PHP-DB] Timestamps On Apr 30, 2008, at 11:35 AM, Stut wrote: > On 30 Apr 2008, at 16:29, Jason Pruim wrote: >> 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? > > timestamp is a reserved word. Try putting it in backticks. Okay, so I did a really crappy job at my sudo code... The field name is actually Last_Updated. so my update code looks like this: Last_Updated='$modifiedTimestamp' *Slaps his wrist... Bad copy/paste! BAD!!! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [email protected] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php