//Handle date issue
$map_eff_date = $myear."-".$mmonth."-".$mday;


$query = ("UPDATE orders SET map_eff_date='$map_eff_date'");

Watch your syntax. Compare the query. Also you do not need to apply any LIMIT on an update.