Insert Date into database, values stored as array

[KingDavid73]

I'm kinda new to php and stuff, and i need to know how to insert a date into a database. I have it working where if it is typed into a text field in a form, but i want it to work with a select box. There are 3 select boxes, month, day, and year, and each value is put into the same array. Up at the beginning of my code i have my update and insert querys. Everything works, but i just can't figure out how to get the information from the select box array into the database, it just gives me 0000-00-00, so something is wrong. I guess its just that i dont know how the correct syntax for arrays in the query if i'm using $_POST, since no variables are defined.

[bpat1434]

What field type is the database? Datestamp or DateTime?

Once the form is posted to the php page, you can just do this:

// If using DateTime field type:
$time = mktime($_POST['month'].'-'.$_POST['day'].'-'.$_POST['year']);

// If using a Datestamp type:
$time = $_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];

Now use the $time variable to insert it into the database.