/home/mjc1/public_html/adm/vender/vender_formupdate.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<?php
$sub_menu 
'950100';
include_once(
'./_common.php');

$vm_saupja $vm_saupja1."-".$vm_saupja2."-".$vm_saupja3;
$vm_goods_auth "";
if(
$vm_goods_auth1!=''){
    
$vm_goods_auth .= "{$vm_goods_auth1},";
}
if(
$vm_goods_auth2!=''){
    
$vm_goods_auth .= "{$vm_goods_auth2},";
}
if(
$vm_goods_auth3!=''){
    
$vm_goods_auth .= "{$vm_goods_auth3},";
}

/*$add_sql = "";
if($vm_user_pw!='' || $vm_user_pw_ch!='' || $vm_user_pw_re!=''){
    if($vm_user_pw!=$vendermember['vm_user_pw']){
        alert('기존 패스워드가 동일하지 않습니다.'); exit;
    }
    if($vm_user_pw_ch!=$vm_user_pw_re && $vm_user_pw_ch!=''){
        alert('변경 패스워드와 확인 패스워드가 동일하지 않습니다.'); exit;
    }

    $add_sql = ", vm_user_pw = '$vm_user_pw_ch' ";
}*/

$sql_common 
                vm_name                    = '
$vm_name',
                vm_company            = '
$vm_company',
                vm_ceo                    = '
$vm_ceo',
                vm_tel                        = '
$vm_tel',
                vm_hp                        = '
$vm_hp',
                vm_fax                        = '
$vm_fax',
                vm_zip                        = '
$vm_zip',
                vm_addr1                    = '
$vm_addr1',
                vm_addr2                    = '
$vm_addr2',
                vm_email                    = '
$vm_email',
                vm_uptae                    = '
$vm_uptae',
                vm_jongmok            = '
$vm_jongmok'
                "
;

$sql "update {$g5[vender_member]} 
                set 
$sql_common
                where vm_id = '
{$vendermember['vm_user_id']}'
"
;

sql_query($sql);

alert('수정되었습니다.',"./vender_form.php?w=u&amp;vm_id=$vm_id&amp;$qstr");

?>