joining multiple form values for db insertion?

[kath421]

Is it possible to combine values from multiple dropdown fields in a form to create one value to submit to a database?

For example can I have DAY, MONTH and YEAR drop down selectors and somehow have these submit to the database as a single yyyy-mm-dd value? I'm looking at a lot of rewriting if it's not possible.

Alternatively, would it be more appropriate to use one of those popup calendarish date selectors? I'd really rather not do that unless I have to.

Any suggestions, or pointers to decent tutorials? Have googled, but with not much result.

[drew010]

its quite easy to combine the 3 fields.

say you have this html

<select name="month">
  <option>01</option>
  <option>....</option>
</select>

<select name="day">
...
</select>

<select name="year">
...
</select>

you can use the following php to put the 3 together and insert them into the db as one variable.

<?php

$date = $_POST['year'] . "-" . $_POST['month'] . "-" . $_POST['day'];

echo $date; //2005-06-01

[kath421]

ahh, suspected something like that. thank you, it's working now.

for reference, i used the code below:

$date = $year . "-" . $month . "-" . $day; 
$event_add = "INSERT INTO event (event_id, event_date, event_time, event_venue, event_cover, artist_id) VALUES ('','$date', '$time', '$venue', '$cover','$artist')";