You can use something like

    $articleDate= date ("Y-m-d 00:00:00",strtotime($day ." " . $month . " " 
. $year));

    If $day =  10 and $month = "January" and $year = 2004
    then $articleDate will be set to "2004-01-10 00:00:00"

Then you can insert $articleDate into a datetime field in mysql.

"Irm Jr" <[EMAIL PROTECTED]> wrote in message 

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


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.


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to