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-DB] php mysql dates

On Wed, 28 Jul 2004 14:30:24 -0700, Irm Jr <[EMAIL PROTECTED]> 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

Reply via email to