Re: [PHP-DB] Timestamps

2008-05-02 Thread Jason Pruim
On May 1, 2008, at 8:31 PM, Chris wrote: 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

Re: [PHP-DB] Timestamps

2008-05-02 Thread Philip Thompson
On May 2, 2008, at 8:00 AM, Jason Pruim wrote: On May 1, 2008, at 8:31 PM, Chris wrote: 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

Re: [PHP-DB] Timestamps

2008-05-01 Thread Jason Pruim
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

Re: [PHP-DB] Timestamps

2008-05-01 Thread Philip Thompson
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

Re: [PHP-DB] Timestamps

2008-05-01 Thread Chris
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 :) A little

Re: [PHP-DB] Timestamps

2008-05-01 Thread Chris
Chris wrote: 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 :) A

Re: [PHP-DB] Timestamps

2008-04-30 Thread Stut
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

Re: [PHP-DB] Timestamps

2008-04-30 Thread Jason Pruim
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

Re: [PHP-DB] Timestamps

2008-04-30 Thread Philip Thompson
` 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: php-db@lists.php.net Subject: Re: [PHP-DB] Timestamps On Apr 30, 2008, at 11:35 AM, Stut

[PHP-DB] Timestamps VS Date/Time Types

2001-04-06 Thread Jordan Elver
Hi, I'm getting a bit confused about what date types to use in my applications and MySQL db. I have used timestamps and I know how to format them, convert them and compare them etc but now I am about to build a calender type script and I'm not sure what to use. For example, if I insert a load