I'm having problems with mySQL updating an already-existing date contained within a date field. Using 3 separate form fields for the date,
$duedate = $year . "-" . $month . "-" . $day;
I then have part of my sql query as
"..., dateupdated = '$duedate',..."
The query works without this in there, and the field name is correct. In addition, this method worked for inserting the date originally, so I don't know why it's not updating it.
$duedate = $year . "-" . $month . "-" . $day;
I then have part of my sql query as
"..., dateupdated = '$duedate',..."
The query works without this in there, and the field name is correct. In addition, this method worked for inserting the date originally, so I don't know why it's not updating it.