I'll add to what the others have already said. As was already mentioned, you
need to create three dropdown fields for the birthdate: year, month and day.
I do this by setting up arrays for each field that offers valid date
choices.
$year[2000] = 2000;
$year[2001] = 2001;
$year[2002] = 2002;
etc...
$month['January'] = 01;
$month['February'] = 02;
$month['March'] = 03;
etc...
$day[1] = 01;
$day[2] = 02;
$day[3] = 03;
etc...
I use these arrays with a simple function to set up the dropdown form
elements that stores the selected results in another array: $realdate. When
the form is submitted, I simply stitch the date together into a valid MySQL
DateTime format of YYYY-MM-DD using the values stored in the $realdate
variable...
$realdate['year']."-".$realdate['month']."-".$realdate['day'];
This would insert the date as: 2003-05-21
Monty
> From: [EMAIL PROTECTED] (Vicky)
> Newsgroups: php.general
> Date: Sat, 31 May 2003 15:05:43 +0100
> To: "PHP List" <[EMAIL PROTECTED]>
> Subject: 3 entries going into 1 field
>
> Hi,
>
> I have a registration form, but I would like to add a Date of Birth section.
> Now, because of the different formats of writing it I want to have 3 seperate
> drop down boxes, Date, Month and Year.
>
> However, I then want those 3 dropdowns to go into one field in a mySQL
> database, in DD/MM/YYYY format.
>
> How can I acheive this, in simple language as I'm a newbie to this stuff ^_~
>
> Thanks!
> Vicky
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
