[RESOLVED] php / mysql date
PHP Code:
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
