[RESOLVED] php / mysql date

[Static]

if(strtotime($c_end) !== false) {
    $c_enddate=date('Y-m-d',strtotime($c_end));
}else{
   $c_end='DEFAULT';
}

$query="INSERT INTO contests VALUES(DEFAULT,'" . $c_title . "','" . getUrl($c_url) . "','" . $c_url . "','" . $c_loc . "'," . $c_ref . "," . $c_day . ",'" . $c_host . "'," . $c_enddate . ",DEFAULT,'" . $user . "',0)"; 

the MYSQL table field is DATE (not DATETIME)

its converting properly.... 9/22/2014 = 2014-9-22 but the date is appearing in the table as 0000-00-00??
i know I am missing something stupid lol

[Static]

.... sigh.. yep.. stupid.

forgot the ' 's around the date in the query

[Nightwalker83]

Is this resolved?

[Static]

sorry.. yes