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

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;
}


}



}