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
