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. 

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

$sql = "Update `mytable` set timestamp=UNIX_TIMESTAMP() where Record='1'";



------ Original Message ------
Received: Wed, 30 Apr 2008 10:39:11 AM CDT
From: Jason Pruim <[EMAIL PROTECTED]>
To: Stut <[EMAIL PROTECTED]>Cc: php-db@lists.php.net
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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to