> How would I do the insert statement in php using a date() or now() > function?
$today = date("Ymd"); $query = "INSERT INTO tblDate (fldDate) VALUES ($today)"; ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -----Original Message----- > From: John W. Holmes [mailto:[EMAIL PROTECTED] > Sent: Saturday, March 15, 2003 4:13 PM > To: 'Jeremi Bergman'; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Insert Date > > > I'm having problem inserting the date into my mysql database. What > type > > of field should my date field be? > > How do I insert that into a database, the current date for example? > > "INSERT INTO tblDate (fldDate) VALUES (" . Date() . ")"; > > You should use a DATE column, maybe?? Or a timestamp, depending on what > you want to do. > > The query you'd use is: > > INSERT INTO tblDate (fldDate) VALUES (NOW()) > > where NOW() is a MySQL function, not a PHP one. MySQL date formats are > YYYYMMDD (as an integer) or YYYY-MM-DD (as a string). > > Adapt to your needs. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php