Re: [PHP-DB] Timestamps

On Apr 30, 2008, at 5:03 PM, Philip Thompson wrote:

> On Apr 30, 2008, at 10:54 AM, Jason Pruim wrote:
>> Hi Yves,
>>
>> Thanks for the tip, that worked, I think I'll use that from now on..
>>
>> Just out of curiosity though, any idea why it wasn't working as I  
>> was writing it :)
>
> Did you try putting the query that PHP is generating in phpMyAdmin  
> or MySQL Query Browser? See if it throws an error when attempting to  
> update. It *appears* that the query should work.

No I haven't, I don't have phpMyAdmin installed since I do it all from  
the command line, and I don't pay for hosting yet... But I am going to  
need to change that. I don't believe I have heard about MySQL Query  
Browser though... Is it a webapp? Or do I need to install it on my  
local computer?


>
>
> ~Philip
>
> PS... Was it you, Jason, or someone else who asked about the  
> security of the community knowing their database structure and I  
> encouraged the use of `backticks` around all field and table names?

Yeah it was me... Old habits die hard :) I'm working on converting  
everything :)
>
>
>
>> On Apr 30, 2008, at 11:47 AM, YVES SUCAET wrote:
>>
>>> 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!!!
>
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[email protected]