[Resolved] Displaying a date on forms

[La_Parka]

On a PHP-MySQL project I am working on, I am creating a user profile management system, and one of the fields is the user's birthdate.

I am using a MySQL 'date' (0000-00-00; Year-Month-Day) field for the birthdate, and have an entry form as pictured in the attachment. The registration form adds the birthday into the database through this SQL: "INSERT INTO users SET birthdate='$year-$month-$day'", and each of the selects/inputs in the attachment correspond with their respective variable in the SQL statement.

The problem comes with trying to make this field editable later on. Is it possible to split the 'date' fieldtype into 3 fieldtypes that will display in the 3 respective select/inputs for month, day, and year, or will I have to use another fieldtype altogether to be able to do that?

[HalfaBee]

You could just explode the date

$bits = explode( '-','2003-07-30' );

then you have the 3 parts.
Put it back together with
$date = implode( '-',$bits );

HalfaBee

[La_Parka]

Originally posted by HalfaBee
You could just explode the date

$bits = explode( '-','2003-07-30' );

then you have the 3 parts.
Put it back together with
$date = implode( '-',$bits );

HalfaBee

Forgive my newbie-ness, but how can I explode the date into 3 variables, and how would I go about assigning names to those variables?

[HalfaBee]

You can make the variables like this.

list( $year,$month,$day ) = explode( '-','2003-07-30' );

or you could have accessed the 3 bits as an array

$bits[0] // year
$bits[1] // month
$bits[2] // day

HalfaBee