MySQL’s default date format is 0000-00-000. What I was trying for the last three hours is to use an if statement to test whether the result of a date query returns 0000-00-00 if yes then I want to set the form variable to an empty string (null).
This is what I have done and does not work.
If ($row_rs_contractDetail['licenseEndDate']) {
$licenseEndDate=”’
}
Your help is very much appreciated.
Regards,
Maru
