What about doing the same thing but using UPDATE in lieu of INSERT?
I have tried using the same syntax and several variations, but have been unsuccessful in making it work.
This is one version of what I have attempted:
Code:
//Handle date issue
$map_eff_date=".$myear."-".$mmonth."-".$mday.";
// Define query
$query = "UPDATE orders SET map_eff_date='.$myear."-".$mmonth."-".$mday.', LIMIT 1";
I have also tried:
Code:
$query = "UPDATE orders SET map_eff_date='$map_eff_date', LIMIT 1";
and:
Code:
$query = "UPDATE orders SET map_eff_date='($map_eff_date)', LIMIT 1";