for some reason this isn’t adding the date into the database when a job is set as invoiced. it worked on the old PHP4 setup but since i’ve moved the server to PHP5 its remaining as the default value (0000-00-00) but the invoiced field is still being set to 1
[code=php]
$date = date(Y-m-d);
$query = “UPDATE `jobs` SET invoiced=’1′, date_invoiced=’$date’ WHERE job_no=’$job_no'”;
$this->execute($query);
[CODE]
field name type default value
date_invoiced date 0000-00-00
am i formatting the date wrong as i had a similar problem with dates when i didn’t include the “-” separator in another section of the system. :S