php-general | 2000071
Date: 07/12/00
- Next message: Fredrik Arild Takle: "[PHP] writing to txt-file! if and else!"
- Previous message: dgw <email protected>: "Re: [PHP] flushing formdata / flushing the client to prevent resubmitting formdata ?"
- Next in thread: Michael Teter: "Re: [PHP] RE: [PHP-DB] Adding an DATETIME as a string to a mySQL databse... ."
- Maybe reply: Michael Teter: "Re: [PHP] RE: [PHP-DB] Adding an DATETIME as a string to a mySQL databse... ."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
did you put ' ' around the value?
if you want to enter the current time you can simply do now()
Sincerely
berber
Visit http://www.weberdev.com Today!!!
To see where PHP might take you tomorrow.
-----Original Message-----
From: Mattias Hedman [mailto:mattias <email protected>]
Sent: Wednesday, July 12, 2000 12:05 PM
To: php-general <email protected>
Cc: php-db <email protected>
Subject: [PHP-DB] Adding an DATETIME as a string to a mySQL databse....
Hello all,
I am having troubles adding an value to an mySQL database, the row is set as
DATETIME which should accept strings.
When I build the string using DATE("Y-m-d H:i:s") in PHP and inserts it into
the database the only thing that gets added in the row is DATETIME default
value (0000-00-00 00:00:00).
Why?
Please help.
TIA, Greetings,
Mattias Hedman
-- mattias.hedman <email protected> web programmer-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe <email protected> For additional commands, e-mail: php-general-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Fredrik Arild Takle: "[PHP] writing to txt-file! if and else!"
- Previous message: dgw <email protected>: "Re: [PHP] flushing formdata / flushing the client to prevent resubmitting formdata ?"
- Next in thread: Michael Teter: "Re: [PHP] RE: [PHP-DB] Adding an DATETIME as a string to a mySQL databse... ."
- Maybe reply: Michael Teter: "Re: [PHP] RE: [PHP-DB] Adding an DATETIME as a string to a mySQL databse... ."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

