parsing date string from php into mysql?

[Anon]

hello,

I have the following prob:

Three select fields within the html code having the following attributes:

<select name="day">
<option>1
<option>up to 31
</select>

<select name="month">
<option>january
<option>up to december
</select>

<select name="year">
<option>1996
<option>up to 2032
</select>

Now I want to combine these fields with php and give that parsed date into a field in mySQL that has the following structure:

fullydate date NOT NULL default '0000-00-00',

AS you can see the name of this field is 'fullydate' and it´s set to NOT NULL.

Now my question: How can I insert the values of the select fields into the DB using the correct format? And later on, how can I read it out again that it will be splitted into the three parts again? Like if I want to edit that date using php.

thx for any help.
erik

[dbakker]

I think you can simply insert the date like this:

INSER INTO table (fullydate) VALUES ('$year-$month-$day')

You can extract the date like this:

SELECT DATE_FORMAT(fullydate, '%e') AS day, DATE_FORMAT(fullydate, '%c') AS month, DATE_FORMAT(fullydate, '%Y') AS year FROM table;

Hope it will help you.

Greetings,
Daniël

[Anon]

hey, thx, works perfectly 🙂