updating date field

I am trying to do an update. but for some reason the date is being lost in the process. Among other things, my form has three html <selects> one for month (eMonth), one for day (eDay) and one for year (eYear). This is the code that does the processing: <code> if (isset($_POST['eMonth']) && $_POST['eMonth'] != '') $eMonth = $_POST['eMonth']; else $eMonth = '01'; if (isset($_POST['eDay']) && $_POST['eDay'] != '') $eMonth = $_POST['eDay']; else $eMonth = '01'; if (isset($_POST['eYear']) && $_POST['eYear'] != '') $eYear = $_POST['eYear']; else $eYear = '2007'; <.processing the rest of the form fields.> $updateEventQuery = "UPDATE events SET EventDate = '$eYear-$eMonth-$eDay', AppliedFYE = '$appliedFYE', LocationID = '$eLocation', StartTime = '$eHour:$eMin $eAMPM', Type = '$eType', Format = '$eFormat', Description = '$eDescription', EventApproved = '$eApproved', EventOfficial = '$eOfficial', LastUpdateBy = '".$_SESSION['ContactID']."' WHERE EventID = '".$_GET['eventid']."'"; Echo $updateEvetQuery; // $updateEventResult = mysql_query($updateEventQuery); </code> When I run this, the query string it prints out is: UPDATE events SET EventDate = '2006-10-10', AppliedFYE = '2007', LocationID = '14', StartTime = '5:00 PM', Type = '3', Format = 'BOARD', Description = 'Regular board meeting', EventApproved = '1', EventOfficial = '0', LastUpdateBy = '209' WHERE EventID = '54' When this query is actually run on the DB though, it queries with no errors, and all the data is saved/updated properly *except* the date - it becomes 0000-00-00. Am I missing something? Thanks in advance, -J