I have an HTML form with three dropdown selects:
month, day and year.
I have four fields in my MySQL table:
month, day, year, and date.
The 'date' field is supposed to contain the concatenated values of the year, month and day separated by dashes.
I write this in my PHP:
$data = "UPDATE inventors SET month='$month', day='$day', year='$year', date='$year . "-" . $month . "-" . $day' WHERE lastname=".'"'.$lastname.'"';
The concatenation doesn't work.
What am I doing wrong?