date

[franches]

hi,
how would i be able to insert the date into my database if i have 3 dropdown boxes wherein it contain the month,day & year. i know the basic of inserting data into my database but with this 3 dropdown box i don't have any idea. after submitting, the data selected on these 3 boxes shall be in one field in my database with fieldname Date . any sample codes for this one?

any help will be appreciated.

[eggy ricardo]

Hiya,

If it is just a date field, as far as i know you could do something like...

"{$_POST['year']}-{$_POST['month']}-{$_POST['day']}";

...and use that in your normal INSERT INTO query. year, month and day would need to be the names of the corresponding form elements and the values submitted would need to be in the YYYY, MM and DD formats respectively.

Hope this helps
Cheers

Richard

[franches]

thank you very very much

[SofterLogic UK]

depending on the form you want, you could use mktime()