[RESOLVED] Inserting dates to mySQL db using dropdown in html

[SirBoo]

I have 3 dropdowns in my html form for submitting year, month and day values. However, i have only one date column in my db. Can anybody show me how to achieve this using php, and to submit the date in the yyyy-mm-dd format. Thanks for the help, in advance.

Apache 2.2.3
PHP 5.1.6
MySql 5.0.24a

[Piranha]

Actually it is not that hard to get it to a date in that format:

$date = $_POST['year'] . "-" . $_POST['month'] . "-" . $_POST['day'];
$sql = "INSERT INTO table (datecolumn) VALUES ($date)";

Note that I haven't made anything to handle SQL injection or validate the variables in any other way. You should do that.

[SirBoo]

@...Thank you for your inputs. I did use the concatenation method before but failed to get the desired result when I used it again recently. The second line in your suggestion reminded me to inject codes in my work aided by Dreamweaver 8. The concatenation, as you advised, together with the following code revision, is producing the desired result.

From (Dreamweaver generated code):

GetSQLValueString($_POST['name_of_hidden_field'], "date")

to:

GetSQLValueString($date, "date")