send_cmd($cmd); $data = $db_dpis->get_array(); $PER_TYPE = $data[PER_TYPE]; if($command=="UPDATE"){ if($PER_TYPE==1) $cmd = " update PER_PROMOTE_P set PRO_SUMMARY='$PRO_SUMMARY',UPDATE_USER = $SESS_USERID, UPDATE_DATE = '$UPDATE_DATE' where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POS_ID=$POS_POEM_ID and PER_ID=$PER_ID "; elseif($PER_TYPE==2) $cmd = " update PER_PROMOTE_E set PRO_SUMMARY='$PRO_SUMMARY',UPDATE_USER = $SESS_USERID, UPDATE_DATE = '$UPDATE_DATE' where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POEM_ID=$POS_POEM_ID and PER_ID=$PER_ID "; elseif($PER_TYPE==3) $cmd = " update PER_PROMOTE_E set PRO_SUMMARY='$PRO_SUMMARY',UPDATE_USER = $SESS_USERID, UPDATE_DATE = '$UPDATE_DATE' where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POEM_ID=$POS_POEM_ID and PER_ID=$PER_ID "; $db_dpis->send_cmd($cmd); // $db_dpis->show_error(); // echo "-> $cmd"; } // end if // echo "-> ( ".$PER_TYPE."/".$PRO_DATE."+".$POS_POEM_ID." ) +".$command.":".$cmd; if($POS_POEM_ID && $PRO_DATE){ if($PER_TYPE==1){ $cmd = " select PRO_SUMMARY from PER_PROMOTE_P where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POS_ID=$POS_POEM_ID and PER_ID=$PER_ID "; }elseif($PER_TYPE==2){ $cmd = " select PRO_SUMMARY from PER_PROMOTE_E where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POEM_ID=$POS_POEM_ID and PER_ID=$PER_ID "; }elseif($PER_TYPE==3){ $cmd = " select PRO_SUMMARY from PER_PROMOTE_E where SUBSTR(PRO_DATE, 1, 10)='$PRO_DATE' and POEM_ID=$POS_POEM_ID and PER_ID=$PER_ID "; } // end if $db_dpis->send_cmd($cmd); $data = $db_dpis->get_array(); $PRO_SUMMARY = stripslashes(trim($data[PRO_SUMMARY])); // echo "-> ( ".$PRO_SUMMARY." ) +".$command.":".$cmd; } ?> <?=$webpage_title?> - <?=$MENU_TITLE_LV0?><?if($MENU_ID_LV1){?> - <?=$MENU_TITLE_LV1?><?}?>
แก้ไขข้อมูลสรุป