Home  |  Linux  | Mysql  | PHP  | XML
 
From:Stut Date:Wed Apr 30 09:35:17 2008
Subject:Re: Timestamps
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.

-Stut

-- 
http://stut.net/
Navigate in group php.db at sever news.php.net
Previous Next




  
© No Copyright
You are free to use Anything 		Site Maintained by PHP Developer
Powered By PHP Consultants