[RESOLVED] INSERT date from three drop downs (day, month, year)

[NiallThistle]

I found this very useful function online to display a drop down menu for day, month and year, and display the current date as the selected date.

		FUNCTION DateSelector($inName, $useDate=0)
		{	
        /* create array so we can name months */ 
        $monthName = ARRAY(1=> "January", "February", "March", 
            "April", "May", "June", "July", "August", 
            "September", "October", "November", "December"); 

    /* if date invalid or not supplied, use current time */ 
    IF($useDate == 0) 
    { 
        $useDate = TIME(); 
    } 

    /* make month selector */ 
    ECHO "<SELECT NAME=" . $inName . "Month>\n"; 
    FOR($currentMonth = 1; $currentMonth <= 12; $currentMonth++) 
    { 
        ECHO "<OPTION VALUE=\""; 
        ECHO INTVAL($currentMonth); 
        ECHO "\""; 
        IF(INTVAL(DATE( "m", $useDate))==$currentMonth) 
        { 
            ECHO " SELECTED"; 
        } 
        ECHO ">" . $monthName[$currentMonth] . "\n"; 
    } 
    ECHO "</SELECT>"; 

    /* make day selector */ 
    ECHO "<SELECT NAME=" . $inName . "Day>\n"; 
    FOR($currentDay=1; $currentDay <= 31; $currentDay++) 
    { 
        ECHO "<OPTION VALUE=\"$currentDay\""; 
        IF(INTVAL(DATE( "d", $useDate))==$currentDay) 
        { 
            ECHO " SELECTED"; 
        } 
        ECHO ">$currentDay\n"; 
    } 
    ECHO "</SELECT>"; 

    /* make year selector */ 
    ECHO "<SELECT NAME=" . $inName . "Year>\n"; 
    $startYear = DATE( "Y", $useDate); 
    FOR($currentYear = $startYear - 5; $currentYear <= $startYear+5;$currentYear++) 
    { 
        ECHO "<OPTION VALUE=\"$currentYear\""; 
        IF(DATE( "Y", $useDate)==$currentYear) 
        { 
            ECHO " SELECTED"; 
        } 
        ECHO ">$currentYear\n"; 
    } 
    ECHO "</SELECT>";

	}

	DateSelector( "date"); 

My question is, how would I then output this date to a DATE (0000-00-00) field, using INSERT?

I have the following, which currently submits the other elements of a form perfectly, but can't get the date to post.

           {
           mysql_query("INSERT INTO val_valuations (valuation_job, valuation_date) VALUES('".$_POST["contract"]."', '?????') ")
           or die(mysql_error());
           echo "Contract successfully added.<br><br>Please wait. You will be redirected...";
           }

I have put ????? where my confusion lies.

[Derokorian]

Well you'll have 3 post values to combine. Something like:

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

Then just put the $date variable where the ??? are

[NiallThistle]

That did it, thank you!