Sure I understand Y-m-d. But won't the database cry because the Month is in text format? (January, february....)? Thanks again. Subject: Re: php mysql dates On Wed, 28 Jul 2004 14:30:24 -0700, Irm Jr <irmjr@xxxxxxxx> wrote: > > Hi all, currently I have a form which prompts for the user to choose a > date. The dropdown lists are stored into variables: > > $month //e.g. January, February, ... > $day //e.g 1 - 31 > $year //e.g. 2004 (four digits) > > then combined into > > $articleDate > > How can I manipulate this variable to be in such a format that I can > insert the information into a DATE column in a mySQL database. > > Dates are a bit of a mystery to me as PHP and MySQL handle them > differently. Your help is appreciated. > Y-m-d -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
