DATE field has 1969-12-31

[jeff5656]

I have a DATE field, but if it is blank, the date is stored as: 1969-12-31

 

How do I modify this code to make that date blank unless a user types in a date?

 

$cxr_date = date("Y-m-d", strtotime($_POST['cxr_date']));  

INSERT INTO sarcoid (cxr_date, etc) VALUES ($cxr_date, $etc)

 

Do I have to change that field to NULL instead of NOT NULL??

[Mchl]

 

Do I have to change that field to NULL instead of NOT NULL??

 

Yes you do. And when there is no date insert NULL into it.

[edit] actually... empty string will be enough

 

if(!empty($_POST['cxr_date'])) {
  $cxr_date = "'".date("Y-m-d", strtotime($_POST['cxr_date']))."'";
} else {
  $cxr_date = "";
}

INSERT INTO sarcoid (cxr_date, etc) VALUES ($cxr_date, $etc)