MySQL/PHP Combining 3 vars into 1
I have a database that is functioning properly, but I would like to change the format in which the date is entered.
Currently both the database and the form have the date as "order_date". However I would like to change the form that inserts the record into the database so that there are three separate fields:
month <list/menu>
day <list/menu>
year <textfield>
that become one field (order_date) when inserted into the database.
I've tried several different methods that have not succeeded. The database updates everything except for the date, which defaults to 0000-00-00.
Does anyone know what the correct MySQL language is to achieve this?
|