아래 함수를 참고하세요..

function move_ok($m_ta,$colum,$m_id,$mover,$wr_1,$wr_3,$wr_4,$wr_5,$wr_6)
{
  $db = db_connect();
  $m_ta = $m_ta;
  $se_table    =  "g4_write_$m_ta";
  switch($mover)
{
  case '신청확인':
{
  $query = "update $se_table set wr_7='$mover' where wr_id=$m_id";
      $result02 = @$db->query($query);
      break;
}

  case '이동대기':
{
  $query = "update $se_table set wr_7='$mover' where wr_id=$m_id";
      $result02 = @$db->query($query);
      break;
}

  case '이동완료':
{
      $query = "update $se_table set wr_7='$mover' where wr_id=$m_id";
      $result02 = @$db->query($query);
      $query01 = "select * from g4_write_move_product where wr_3='$wr_3'";
  $result03 = @$db->query($query01);
      $num_cats = @$result03->num_rows;
      if ($num_cats ==0)
{
  $query04 = "insert into g4_write_move_product values ('','','','','','','','','','장착현황','','','','','','','','','','','','','','','','','','----','이동내역','$wr_3','$wr_4','$wr_5','$wr_6','1','$wr_8','$wr_9','$wr_10')";
      $result03 = @$db->query($query04);

    }
      if ($num_cats)
{
          $query04 = "update g4_write_move_product set wr_4='$wr_4',wr_5='$wr_5',wr_6='$wr_6' where wr_3 =$wr_3";
      $result03 = @$db->query($query04); 
}


      break;
}

  case '신청취소':
{
      $query = "update $se_table set wr_7='$mover' where wr_id=$m_id";
      $result02 = @$db->query($query);
      break;
}

  default :
{
      $query = "update $se_table set wr_7='$mover' where wr_id=$m_id";
      $result02 = @$db->query($query);
      break;
}


    }



}