여분필드 wr_90 추가후 "글쓰기"번튼 누르면 먹통이 됩니다 정보
여분필드 wr_90 추가후 "글쓰기"번튼 누르면 먹통이 됩니다
본문
write_update.skin.php 요기서 멈춰 버린건지 완료 된건지 에러도 안뜨니 답답 하네요
DB엔 필드 wr_11 ~ wr_90 추가 하였고요
고수님들의 조언 부탁 드립니다.
>>>> write_update.skin.php 내용----------------------------------------
<?
//header("Content-type: text/html; charset=UTF-8");
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
/*
//=========================================================== 지업로더 후처리
if ($w == ''|| $w== "r"){
$wr_id_code=abs(ip2long($_SERVER['REMOTE_ADDR']));
if($wr_id_code >= 2147483647)
$wr_id_code=substr($wr_id_code,-9);
$sql = "update g4_board_file set wr_id = '$wr_id' where bo_table = '$bo_table' and wr_id = '$wr_id_code'";
sql_query($sql);
}
*/
if ($w != 'c') {
if($wr_01 == ""){$wr_01 = "Y";} //승인유무("Y"자동승인)
$sql01= "update $write_table set wr_1 = '$wr_01' where wr_id = '$wr_id'";
sql_query($sql01);
$wr_02 = "$mg010";
$sql02 = "update $write_table set wr_2 = '$wr_02' where wr_id = '$wr_id'";
sql_query($sql02) // ♧ 담당 매니저 코드
$wr_03 = "mg020";
$sql03 = "update $write_table set wr_3 = '$wr_03' where wr_id = '$wr_id'";
sql_query($sql03) // ♧ 담당 매니저
$wr_04 = "$mg03_tel01|$mg03_tel02|$mg03_tel03";
$sql04 = "update $write_table set wr_4 = '$wr_04' where wr_id = '$wr_id'";
sql_query($sql04) //3 ♧ 담당 매니저 연락처
$wr_05 = "$mg040";
$sql05 = "update $write_table set wr_5 = '$wr_05' where wr_id = '$wr_id'";
sql_query($sql05) // ♧ 담당 매니저 이메일
$wr_06 = "$mg050";
$sql06 = "update $write_table set wr_6 = '$wr_06' where wr_id = '$wr_id'";
sql_query($sql06) // ♧ 담당 매니저 한마디 (txt)
$wr_07 = "$mg060";
$sql07 = "update $write_table set wr_7 = '$wr_07' where wr_id = '$wr_id'";
sql_query($sql07) // ♣ 담당 팀장 코드
$wr_08 = "$mg070";
$sql08 = "update $write_table set wr_8 = '$wr_08' where wr_id = '$wr_id'";
sql_query($sql08) // ♣ 당당 팀장
$wr_09 = "$mg08_tel01|$mg08_tel02|$mg08_tel03";
$sql09 = "update $write_table set wr_9 = '$wr_09' where wr_id = '$wr_id'";
sql_query($sql09) //3 ♣ 담당 팀장연락처
$wr_10 = "$mg090";
$sql10 = "update $write_table set wr_10 = '$wr_10' where wr_id = '$wr_id'";
sql_query($sql10) // ♣ 담당 팀장 코치 (txt)
$wr_11 = "$sys010";
$sql11 = "update $write_table set wr_11 = '$wr_11' where wr_id = '$wr_id'";
sql_query($sql11) // ♡ 결혼구분
$wr_12 = "$sys020";
$sql12 = "update $write_table set wr_12 = '$wr_12' where wr_id = '$wr_id'";
sql_query($sql12) // ♡ 회원상태
$wr_13 = "$sys030";
$sql13 = "update $write_table set wr_13 = '$wr_13' where wr_id = '$wr_id'";
sql_query($sql13) // ♡ 회원번호
$wr_14 = "$sys040";
$sql14 = "update $write_table set wr_14 = '$wr_14' where wr_id = '$wr_id'";
sql_query($sql14) // ♡ 가입경로
$wr_15 = "$sys050";
$sql15 = "update $write_table set wr_15 = '$wr_15' where wr_id = '$wr_id'";
sql_query($sql15) // ♡ 연결상태
$wr_16 = "$sys06_fyy|$sys06_fmm|$sys06_fdd";
$sql16 = "update $write_table set wr_16 = '$wr_16' where wr_id = '$wr_id'";
sql_query($sql16) //3 ♡ 최초연결
$wr_17 = "$sys07_lyy|$sys07_lmm|$sys07_ldd";
$sql17 = "update $write_table set wr_17 = '$wr_17' where wr_id = '$wr_id'";
sql_query($sql17) //3 ♡ 최종연결
$wr_18 = "$sys080";
$sql18 = "update $write_table set wr_18 = '$wr_18' where wr_id = '$wr_id'";
sql_query($sql18) // ♡ 상품
$wr_19 = "$sys090";
$sql19 = "update $write_table set wr_19 = '$wr_19' where wr_id = '$wr_id'";
sql_query($sql19) // ♡ 비용
$wr_20 = "$sys100";
$sql20 = "update $write_table set wr_20 = '$wr_20' where wr_id = '$wr_id'";
sql_query($sql20) // ♡ 결재상태
$wr_21 = "$pf010";
$sql21 = "update $write_table set wr_21 = '$wr_21' where wr_id = '$wr_id'";
sql_query($sql21) // · 이름 v
$wr_22 = "$pf020";
$sql22 = "update $write_table set wr_22 = '$wr_22' where wr_id = '$wr_id'";
sql_query($sql22) // · 애칭
$wr_23 = "$pf030";
$sql23 = "update $write_table set wr_23 = '$wr_23' where wr_id = '$wr_id'";
sql_query($sql23) // · 성별 v
$wr_24 = "$pf04_jumin1|$pf04_jumin2";
$sql24 = "update $write_table set wr_24 = '$wr_24' where wr_id = '$wr_id'";
sql_query($sql24) //2 · 주민번호
$wr_25 = "$pf05_birth1|$pf05_birth2|$pf05_birth3|$pf05_birth4";
$sql25 = "update $write_table set wr_25 = '$wr_25' where wr_id = '$wr_id'";
sql_query($sql25) //4 · 생년월일
$wr_26 = "$pf060";
$sql26 = "update $write_table set wr_26 = '$wr_26' where wr_id = '$wr_id'";
sql_query($sql26) // · 나이
$wr_27 = "$pf070";
$sql27 = "update $write_table set wr_27 = '$wr_27' where wr_id = '$wr_id'";
sql_query($sql27) // · 띠
$wr_28 = "$pf080";
$sql28 = "update $write_table set wr_28 = '$wr_28' where wr_id = '$wr_id'";
sql_query($sql28) // · 별자리
$wr_29 = "$pf09_home1|$pf09_home2";
$sql29 = "update $write_table set wr_29 = '$wr_29' where wr_id = '$wr_id'";
sql_query($sql29) //2 · 고향
$wr_30 = "$pf10_tel01|$pf10_tel02|$pf10_tel03";
$sql30 = "update $write_table set wr_30 = '$wr_30' where wr_id = '$wr_id'";
sql_query($sql30) //3 · 전화번호
$wr_31 = "$pf11_hp01|$pf11_hp02|$pf11_hp03";
$sql31 = "update $write_table set wr_31 = '$wr_31' where wr_id = '$wr_id'";
sql_query($sql31) //3 · 휴대폰 v
$wr_32 = "$pf120";
$sql32 = "update $write_table set wr_32 = '$wr_32' where wr_id = '$wr_id'";
sql_query($sql32) // · 이메일 v
$wr_33 = "$pf130";
$sql33 = "update $write_table set wr_33 = '$wr_33' where wr_id = '$wr_id'";
sql_query($sql33) // · 홈페이지
$wr_34 = "$pf14_zip1|$pf14_zip2|$pf14_add1|$pf14_add2";
$sql34 = "update $write_table set wr_34 = '$wr_34' where wr_id = '$wr_id'";
sql_query($sql34) //4 · 주소
$wr_35 = "$pf15_scp1|$pf15_scp2|$pf15_scp3|$pf15_scp4";
$sql35 = "update $write_table set wr_35 = '$wr_35' where wr_id = '$wr_id'";
sql_query($sql35) //4 · 학력(학교명/학교/학년/전공)
$wr_36 = "$pf160";
$sql36 = "update $write_table set wr_36 = '$wr_36' where wr_id = '$wr_id'";
sql_query($sql36) // · 학위
$wr_37 = "$pf170";
$sql37 = "update $write_table set wr_37 = '$wr_37' where wr_id = '$wr_id'";
sql_query($sql37) // · 사회경력
$wr_38 = "$pf180";
$sql38 = "update $write_table set wr_38 = '$wr_38' where wr_id = '$wr_id'";
sql_query($sql38) // · 종교
$wr_39 = "$pf19_job1|$pf19_job2";
$sql39 = "update $write_table set wr_39 = '$wr_39' where wr_id = '$wr_id'";
sql_query($sql39) //2 · 직업
$wr_40 = "$pf200";
$sql40 = "update $write_table set wr_40 = '$wr_40' where wr_id = '$wr_id'";
sql_query($sql40) // · 직위
$wr_41 = "$pf210";
$sql41 = "update $write_table set wr_41 = '$wr_41' where wr_id = '$wr_id'";
sql_query($sql41) // · 년봉
$wr_42 = "$pf220";
$sql42 = "update $write_table set wr_42 = '$wr_42' where wr_id = '$wr_id'";
sql_query($sql42) // · 주거형태
$wr_43 = "$pf230";
$sql43 = "update $write_table set wr_43 = '$wr_43' where wr_id = '$wr_id'";
sql_query($sql43) // · 주거소유
$wr_44 = "$pf240";
$sql44 = "update $write_table set wr_44 = '$wr_44' where wr_id = '$wr_id'";
sql_query($sql44) // · 승용차소유
$wr_45 = "$pf251|$pf252|$pf253|";
$sql45 = "update $write_table set wr_45 = '$wr_45' where wr_id = '$wr_id'";
sql_query($sql45) //3 · 가족관계
$wr_46 = "$pf261|$pf262";
$sql46 = "update $write_table set wr_46 = '$wr_46' where wr_id = '$wr_id'";
sql_query($sql46) //2 · 부모님나이
$wr_47 = "$pf270";
$sql47 = "update $write_table set wr_47 = '$wr_47' where wr_id = '$wr_id'";
sql_query($sql47) // · 부모님동거관계
$wr_48 = "$pf280";
$sql48 = "update $write_table set wr_48 = '$wr_48' where wr_id = '$wr_id'";
sql_query($sql48) // · 재혼의경우(사별/이혼)
$wr_49 = "$pf291|$pf292";
$sql49 = "update $write_table set wr_49 = '$wr_49' where wr_id = '$wr_id'";
sql_query($sql49) //2 · 재혼의경우자녀(남,여)
$wr_50 = "$pf300";
$sql50 = "update $write_table set wr_50 = '$wr_50' where wr_id = '$wr_id'";
sql_query($sql50) // · 본관
$wr_51 = "$pf310";
$sql51 = "update $write_table set wr_51 = '$wr_51' where wr_id = '$wr_id'";
sql_query($sql51) // · 외모
$wr_52 = "$pf320";
$sql52 = "update $write_table set wr_52 = '$wr_52' where wr_id = '$wr_id'";
sql_query($sql52) // · 체형
$wr_53 = "$pf330";
$sql53 = "update $write_table set wr_53 = '$wr_53' where wr_id = '$wr_id'";
sql_query($sql53) // · 신장
$wr_54 = "$pf340";
$sql54 = "update $write_table set wr_54 = '$wr_54' where wr_id = '$wr_id'";
sql_query($sql54) // · 몸무게
$wr_55 = "$pf350";
$sql55 = "update $write_table set wr_55 = '$wr_55' where wr_id = '$wr_id'";
sql_query($sql55) // · 혈액형
$wr_56 = "$pf360";
$sql56 = "update $write_table set wr_56 = '$wr_56' where wr_id = '$wr_id'";
sql_query($sql56) // · 병역
$wr_57 = "$pf370";
$sql57 = "update $write_table set wr_57 = '$wr_57' where wr_id = '$wr_id'";
sql_query($sql57) // · 안경착용
$wr_58 = "$pf380";
$sql58 = "update $write_table set wr_58 = '$wr_58' where wr_id = '$wr_id'";
sql_query($sql58) // · 흡연
$wr_59 = "$pf390";
$sql59 = "update $write_table set wr_59 = '$wr_59' where wr_id = '$wr_id'";
sql_query($sql59) // · 음주
$wr_60 = "$pf400";
$sql60 = "update $write_table set wr_60 = '$wr_60' where wr_id = '$wr_id'";
sql_query($sql60) // · 건강상태
$wr_61 = "$pf410";
$sql61 = "update $write_table set wr_61 = '$wr_61' where wr_id = '$wr_id'";
sql_query($sql61) // · 첫인상
$wr_62 = "$pf420";
$sql62 = "update $write_table set wr_62 = '$wr_62' where wr_id = '$wr_id'";
sql_query($sql62) // · 성격
$wr_63 = "$pf430";
$sql63 = "update $write_table set wr_63 = '$wr_63' where wr_id = '$wr_id'";
sql_query($sql63) // · 취미
$wr_64 = "$pf440";
$sql64 = "update $write_table set wr_64 = '$wr_64' where wr_id = '$wr_id'";
sql_query($sql64) // · 특기
$wr_65 = "$pf450";
$sql65 = "update $write_table set wr_65 = '$wr_65' where wr_id = '$wr_id'";
sql_query($sql65) // · 나의 매력 (txt)
$wr_66 = "$hope010";
$sql66 = "update $write_table set wr_66 = '$wr_66' where wr_id = '$wr_id'";
sql_query($sql66) // ♥ 성별
$wr_67 = "$hope020";
$sql67 = "update $write_table set wr_67 = '$wr_67' where wr_id = '$wr_id'";
sql_query($sql67) // ♥ 연령
$wr_68 = "$hope030";
$sql68 = "update $write_table set wr_68 = '$wr_68' where wr_id = '$wr_id'";
sql_query($sql68) // ♥ 혈액형
$wr_69 = "$hope040";
$sql69 = "update $write_table set wr_69 = '$wr_69' where wr_id = '$wr_id'";
sql_query($sql69) // ♥ 체형
$wr_70 = "$hope050";
$sql70 = "update $write_table set wr_70 = '$wr_70' where wr_id = '$wr_id'";
sql_query($sql70) // ♥ 신장
$wr_71 = "$hope060";
$sql71 = "update $write_table set wr_71 = '$wr_71' where wr_id = '$wr_id'";
sql_query($sql71) // ♥ 몸무게
$wr_72 = "$hope070";
$sql72 = "update $write_table set wr_72 = '$wr_72' where wr_id = '$wr_id'";
sql_query($sql72) // ♥ 안경착용
$wr_73 = "$hope080";
$sql73 = "update $write_table set wr_73 = '$wr_73' where wr_id = '$wr_id'";
sql_query($sql73) // ♥ 흡연
$wr_74 = "$hope090";
$sql74 = "update $write_table set wr_74 = '$wr_74' where wr_id = '$wr_id'";
sql_query($sql74) // ♥ 음주
$wr_75 = "$hope100";
$sql75 = "update $write_table set wr_75 = '$wr_75' where wr_id = '$wr_id'";
sql_query($sql75) // ♥ 종교
$wr_76 = "$hope110";
$sql76 = "update $write_table set wr_76 = '$wr_76' where wr_id = '$wr_id'";
sql_query($sql76) // ♥ 학력
$wr_77 = "$hope121_job1|$hope121_job2";
$sql77 = "update $write_table set wr_77 = '$wr_77' where wr_id = '$wr_id'";
sql_query($sql77) //2 ♥ 직업 1차
$wr_78 = "$hope122_job1|$hope122_job2";
$sql78 = "update $write_table set wr_78 = '$wr_78' where wr_id = '$wr_id'";
sql_query($sql78) //2 ♥ 직업 2차
$wr_79 = "$hope123_job1|$hope123_job2";
$sql79 = "update $write_table set wr_79 = '$wr_79' where wr_id = '$wr_id'";
sql_query($sql79) //2 ♥ 직업 3차
$wr_80 = "$hope130";
$sql80 = "update $write_table set wr_80 = '$wr_80' where wr_id = '$wr_id'";
sql_query($sql80) // ♥ 연소득
$wr_81 = "$hope150";
$sql81 = "update $write_table set wr_81 = '$wr_81' where wr_id = '$wr_id'";
sql_query($sql81) // ♥ 주거형태
$wr_82 = "$hope160";
$sql82 = "update $write_table set wr_82 = '$wr_82' where wr_id = '$wr_id'";
sql_query($sql82) // ♥ 주거소유
$wr_83 = "$hope170";
$sql83 = "update $write_table set wr_83 = '$wr_83' where wr_id = '$wr_id'";
sql_query($sql83) // ♥ 승용차소유
$wr_84 = "$hope180";
$sql84 = "update $write_table set wr_84 = '$wr_84' where wr_id = '$wr_id'";
sql_query($sql84) // ♥ 첫인상
$wr_85 = "$hope190";
$sql85 = "update $write_table set wr_85 = '$wr_85' where wr_id = '$wr_id'";
sql_query($sql85) // ♥ 성격
$wr_86 = "$hope200";
$sql86 = "update $write_table set wr_86 = '$wr_86' where wr_id = '$wr_id'";
sql_query($sql86) // ♥ 특기
$wr_87 = "$hope210";
$sql87 = "update $write_table set wr_87 = '$wr_87' where wr_id = '$wr_id'";
sql_query($sql87) // ♥ 취미
$wr_88 = "$hope220";
$sql88 = "update $write_table set wr_88 = '$wr_88' where wr_id = '$wr_id'";
sql_query($sql88) // ♥ 상대혼인경력
$wr_89 = "$hope230";
$sql89 = "update $write_table set wr_89 = '$wr_89' where wr_id = '$wr_id'";
sql_query($sql89) // ♥ 배우자선택기준 (txt)
$wr_90 = "$hope240";
$sql90 = "update $write_table set wr_90 = '$wr_90' where wr_id = '$wr_id'";
sql_query($sql90) // ♥ 나의이상형 (txt)
}
?>
DB엔 필드 wr_11 ~ wr_90 추가 하였고요
고수님들의 조언 부탁 드립니다.
>>>> write_update.skin.php 내용----------------------------------------
<?
//header("Content-type: text/html; charset=UTF-8");
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
/*
//=========================================================== 지업로더 후처리
if ($w == ''|| $w== "r"){
$wr_id_code=abs(ip2long($_SERVER['REMOTE_ADDR']));
if($wr_id_code >= 2147483647)
$wr_id_code=substr($wr_id_code,-9);
$sql = "update g4_board_file set wr_id = '$wr_id' where bo_table = '$bo_table' and wr_id = '$wr_id_code'";
sql_query($sql);
}
*/
if ($w != 'c') {
if($wr_01 == ""){$wr_01 = "Y";} //승인유무("Y"자동승인)
$sql01= "update $write_table set wr_1 = '$wr_01' where wr_id = '$wr_id'";
sql_query($sql01);
$wr_02 = "$mg010";
$sql02 = "update $write_table set wr_2 = '$wr_02' where wr_id = '$wr_id'";
sql_query($sql02) // ♧ 담당 매니저 코드
$wr_03 = "mg020";
$sql03 = "update $write_table set wr_3 = '$wr_03' where wr_id = '$wr_id'";
sql_query($sql03) // ♧ 담당 매니저
$wr_04 = "$mg03_tel01|$mg03_tel02|$mg03_tel03";
$sql04 = "update $write_table set wr_4 = '$wr_04' where wr_id = '$wr_id'";
sql_query($sql04) //3 ♧ 담당 매니저 연락처
$wr_05 = "$mg040";
$sql05 = "update $write_table set wr_5 = '$wr_05' where wr_id = '$wr_id'";
sql_query($sql05) // ♧ 담당 매니저 이메일
$wr_06 = "$mg050";
$sql06 = "update $write_table set wr_6 = '$wr_06' where wr_id = '$wr_id'";
sql_query($sql06) // ♧ 담당 매니저 한마디 (txt)
$wr_07 = "$mg060";
$sql07 = "update $write_table set wr_7 = '$wr_07' where wr_id = '$wr_id'";
sql_query($sql07) // ♣ 담당 팀장 코드
$wr_08 = "$mg070";
$sql08 = "update $write_table set wr_8 = '$wr_08' where wr_id = '$wr_id'";
sql_query($sql08) // ♣ 당당 팀장
$wr_09 = "$mg08_tel01|$mg08_tel02|$mg08_tel03";
$sql09 = "update $write_table set wr_9 = '$wr_09' where wr_id = '$wr_id'";
sql_query($sql09) //3 ♣ 담당 팀장연락처
$wr_10 = "$mg090";
$sql10 = "update $write_table set wr_10 = '$wr_10' where wr_id = '$wr_id'";
sql_query($sql10) // ♣ 담당 팀장 코치 (txt)
$wr_11 = "$sys010";
$sql11 = "update $write_table set wr_11 = '$wr_11' where wr_id = '$wr_id'";
sql_query($sql11) // ♡ 결혼구분
$wr_12 = "$sys020";
$sql12 = "update $write_table set wr_12 = '$wr_12' where wr_id = '$wr_id'";
sql_query($sql12) // ♡ 회원상태
$wr_13 = "$sys030";
$sql13 = "update $write_table set wr_13 = '$wr_13' where wr_id = '$wr_id'";
sql_query($sql13) // ♡ 회원번호
$wr_14 = "$sys040";
$sql14 = "update $write_table set wr_14 = '$wr_14' where wr_id = '$wr_id'";
sql_query($sql14) // ♡ 가입경로
$wr_15 = "$sys050";
$sql15 = "update $write_table set wr_15 = '$wr_15' where wr_id = '$wr_id'";
sql_query($sql15) // ♡ 연결상태
$wr_16 = "$sys06_fyy|$sys06_fmm|$sys06_fdd";
$sql16 = "update $write_table set wr_16 = '$wr_16' where wr_id = '$wr_id'";
sql_query($sql16) //3 ♡ 최초연결
$wr_17 = "$sys07_lyy|$sys07_lmm|$sys07_ldd";
$sql17 = "update $write_table set wr_17 = '$wr_17' where wr_id = '$wr_id'";
sql_query($sql17) //3 ♡ 최종연결
$wr_18 = "$sys080";
$sql18 = "update $write_table set wr_18 = '$wr_18' where wr_id = '$wr_id'";
sql_query($sql18) // ♡ 상품
$wr_19 = "$sys090";
$sql19 = "update $write_table set wr_19 = '$wr_19' where wr_id = '$wr_id'";
sql_query($sql19) // ♡ 비용
$wr_20 = "$sys100";
$sql20 = "update $write_table set wr_20 = '$wr_20' where wr_id = '$wr_id'";
sql_query($sql20) // ♡ 결재상태
$wr_21 = "$pf010";
$sql21 = "update $write_table set wr_21 = '$wr_21' where wr_id = '$wr_id'";
sql_query($sql21) // · 이름 v
$wr_22 = "$pf020";
$sql22 = "update $write_table set wr_22 = '$wr_22' where wr_id = '$wr_id'";
sql_query($sql22) // · 애칭
$wr_23 = "$pf030";
$sql23 = "update $write_table set wr_23 = '$wr_23' where wr_id = '$wr_id'";
sql_query($sql23) // · 성별 v
$wr_24 = "$pf04_jumin1|$pf04_jumin2";
$sql24 = "update $write_table set wr_24 = '$wr_24' where wr_id = '$wr_id'";
sql_query($sql24) //2 · 주민번호
$wr_25 = "$pf05_birth1|$pf05_birth2|$pf05_birth3|$pf05_birth4";
$sql25 = "update $write_table set wr_25 = '$wr_25' where wr_id = '$wr_id'";
sql_query($sql25) //4 · 생년월일
$wr_26 = "$pf060";
$sql26 = "update $write_table set wr_26 = '$wr_26' where wr_id = '$wr_id'";
sql_query($sql26) // · 나이
$wr_27 = "$pf070";
$sql27 = "update $write_table set wr_27 = '$wr_27' where wr_id = '$wr_id'";
sql_query($sql27) // · 띠
$wr_28 = "$pf080";
$sql28 = "update $write_table set wr_28 = '$wr_28' where wr_id = '$wr_id'";
sql_query($sql28) // · 별자리
$wr_29 = "$pf09_home1|$pf09_home2";
$sql29 = "update $write_table set wr_29 = '$wr_29' where wr_id = '$wr_id'";
sql_query($sql29) //2 · 고향
$wr_30 = "$pf10_tel01|$pf10_tel02|$pf10_tel03";
$sql30 = "update $write_table set wr_30 = '$wr_30' where wr_id = '$wr_id'";
sql_query($sql30) //3 · 전화번호
$wr_31 = "$pf11_hp01|$pf11_hp02|$pf11_hp03";
$sql31 = "update $write_table set wr_31 = '$wr_31' where wr_id = '$wr_id'";
sql_query($sql31) //3 · 휴대폰 v
$wr_32 = "$pf120";
$sql32 = "update $write_table set wr_32 = '$wr_32' where wr_id = '$wr_id'";
sql_query($sql32) // · 이메일 v
$wr_33 = "$pf130";
$sql33 = "update $write_table set wr_33 = '$wr_33' where wr_id = '$wr_id'";
sql_query($sql33) // · 홈페이지
$wr_34 = "$pf14_zip1|$pf14_zip2|$pf14_add1|$pf14_add2";
$sql34 = "update $write_table set wr_34 = '$wr_34' where wr_id = '$wr_id'";
sql_query($sql34) //4 · 주소
$wr_35 = "$pf15_scp1|$pf15_scp2|$pf15_scp3|$pf15_scp4";
$sql35 = "update $write_table set wr_35 = '$wr_35' where wr_id = '$wr_id'";
sql_query($sql35) //4 · 학력(학교명/학교/학년/전공)
$wr_36 = "$pf160";
$sql36 = "update $write_table set wr_36 = '$wr_36' where wr_id = '$wr_id'";
sql_query($sql36) // · 학위
$wr_37 = "$pf170";
$sql37 = "update $write_table set wr_37 = '$wr_37' where wr_id = '$wr_id'";
sql_query($sql37) // · 사회경력
$wr_38 = "$pf180";
$sql38 = "update $write_table set wr_38 = '$wr_38' where wr_id = '$wr_id'";
sql_query($sql38) // · 종교
$wr_39 = "$pf19_job1|$pf19_job2";
$sql39 = "update $write_table set wr_39 = '$wr_39' where wr_id = '$wr_id'";
sql_query($sql39) //2 · 직업
$wr_40 = "$pf200";
$sql40 = "update $write_table set wr_40 = '$wr_40' where wr_id = '$wr_id'";
sql_query($sql40) // · 직위
$wr_41 = "$pf210";
$sql41 = "update $write_table set wr_41 = '$wr_41' where wr_id = '$wr_id'";
sql_query($sql41) // · 년봉
$wr_42 = "$pf220";
$sql42 = "update $write_table set wr_42 = '$wr_42' where wr_id = '$wr_id'";
sql_query($sql42) // · 주거형태
$wr_43 = "$pf230";
$sql43 = "update $write_table set wr_43 = '$wr_43' where wr_id = '$wr_id'";
sql_query($sql43) // · 주거소유
$wr_44 = "$pf240";
$sql44 = "update $write_table set wr_44 = '$wr_44' where wr_id = '$wr_id'";
sql_query($sql44) // · 승용차소유
$wr_45 = "$pf251|$pf252|$pf253|";
$sql45 = "update $write_table set wr_45 = '$wr_45' where wr_id = '$wr_id'";
sql_query($sql45) //3 · 가족관계
$wr_46 = "$pf261|$pf262";
$sql46 = "update $write_table set wr_46 = '$wr_46' where wr_id = '$wr_id'";
sql_query($sql46) //2 · 부모님나이
$wr_47 = "$pf270";
$sql47 = "update $write_table set wr_47 = '$wr_47' where wr_id = '$wr_id'";
sql_query($sql47) // · 부모님동거관계
$wr_48 = "$pf280";
$sql48 = "update $write_table set wr_48 = '$wr_48' where wr_id = '$wr_id'";
sql_query($sql48) // · 재혼의경우(사별/이혼)
$wr_49 = "$pf291|$pf292";
$sql49 = "update $write_table set wr_49 = '$wr_49' where wr_id = '$wr_id'";
sql_query($sql49) //2 · 재혼의경우자녀(남,여)
$wr_50 = "$pf300";
$sql50 = "update $write_table set wr_50 = '$wr_50' where wr_id = '$wr_id'";
sql_query($sql50) // · 본관
$wr_51 = "$pf310";
$sql51 = "update $write_table set wr_51 = '$wr_51' where wr_id = '$wr_id'";
sql_query($sql51) // · 외모
$wr_52 = "$pf320";
$sql52 = "update $write_table set wr_52 = '$wr_52' where wr_id = '$wr_id'";
sql_query($sql52) // · 체형
$wr_53 = "$pf330";
$sql53 = "update $write_table set wr_53 = '$wr_53' where wr_id = '$wr_id'";
sql_query($sql53) // · 신장
$wr_54 = "$pf340";
$sql54 = "update $write_table set wr_54 = '$wr_54' where wr_id = '$wr_id'";
sql_query($sql54) // · 몸무게
$wr_55 = "$pf350";
$sql55 = "update $write_table set wr_55 = '$wr_55' where wr_id = '$wr_id'";
sql_query($sql55) // · 혈액형
$wr_56 = "$pf360";
$sql56 = "update $write_table set wr_56 = '$wr_56' where wr_id = '$wr_id'";
sql_query($sql56) // · 병역
$wr_57 = "$pf370";
$sql57 = "update $write_table set wr_57 = '$wr_57' where wr_id = '$wr_id'";
sql_query($sql57) // · 안경착용
$wr_58 = "$pf380";
$sql58 = "update $write_table set wr_58 = '$wr_58' where wr_id = '$wr_id'";
sql_query($sql58) // · 흡연
$wr_59 = "$pf390";
$sql59 = "update $write_table set wr_59 = '$wr_59' where wr_id = '$wr_id'";
sql_query($sql59) // · 음주
$wr_60 = "$pf400";
$sql60 = "update $write_table set wr_60 = '$wr_60' where wr_id = '$wr_id'";
sql_query($sql60) // · 건강상태
$wr_61 = "$pf410";
$sql61 = "update $write_table set wr_61 = '$wr_61' where wr_id = '$wr_id'";
sql_query($sql61) // · 첫인상
$wr_62 = "$pf420";
$sql62 = "update $write_table set wr_62 = '$wr_62' where wr_id = '$wr_id'";
sql_query($sql62) // · 성격
$wr_63 = "$pf430";
$sql63 = "update $write_table set wr_63 = '$wr_63' where wr_id = '$wr_id'";
sql_query($sql63) // · 취미
$wr_64 = "$pf440";
$sql64 = "update $write_table set wr_64 = '$wr_64' where wr_id = '$wr_id'";
sql_query($sql64) // · 특기
$wr_65 = "$pf450";
$sql65 = "update $write_table set wr_65 = '$wr_65' where wr_id = '$wr_id'";
sql_query($sql65) // · 나의 매력 (txt)
$wr_66 = "$hope010";
$sql66 = "update $write_table set wr_66 = '$wr_66' where wr_id = '$wr_id'";
sql_query($sql66) // ♥ 성별
$wr_67 = "$hope020";
$sql67 = "update $write_table set wr_67 = '$wr_67' where wr_id = '$wr_id'";
sql_query($sql67) // ♥ 연령
$wr_68 = "$hope030";
$sql68 = "update $write_table set wr_68 = '$wr_68' where wr_id = '$wr_id'";
sql_query($sql68) // ♥ 혈액형
$wr_69 = "$hope040";
$sql69 = "update $write_table set wr_69 = '$wr_69' where wr_id = '$wr_id'";
sql_query($sql69) // ♥ 체형
$wr_70 = "$hope050";
$sql70 = "update $write_table set wr_70 = '$wr_70' where wr_id = '$wr_id'";
sql_query($sql70) // ♥ 신장
$wr_71 = "$hope060";
$sql71 = "update $write_table set wr_71 = '$wr_71' where wr_id = '$wr_id'";
sql_query($sql71) // ♥ 몸무게
$wr_72 = "$hope070";
$sql72 = "update $write_table set wr_72 = '$wr_72' where wr_id = '$wr_id'";
sql_query($sql72) // ♥ 안경착용
$wr_73 = "$hope080";
$sql73 = "update $write_table set wr_73 = '$wr_73' where wr_id = '$wr_id'";
sql_query($sql73) // ♥ 흡연
$wr_74 = "$hope090";
$sql74 = "update $write_table set wr_74 = '$wr_74' where wr_id = '$wr_id'";
sql_query($sql74) // ♥ 음주
$wr_75 = "$hope100";
$sql75 = "update $write_table set wr_75 = '$wr_75' where wr_id = '$wr_id'";
sql_query($sql75) // ♥ 종교
$wr_76 = "$hope110";
$sql76 = "update $write_table set wr_76 = '$wr_76' where wr_id = '$wr_id'";
sql_query($sql76) // ♥ 학력
$wr_77 = "$hope121_job1|$hope121_job2";
$sql77 = "update $write_table set wr_77 = '$wr_77' where wr_id = '$wr_id'";
sql_query($sql77) //2 ♥ 직업 1차
$wr_78 = "$hope122_job1|$hope122_job2";
$sql78 = "update $write_table set wr_78 = '$wr_78' where wr_id = '$wr_id'";
sql_query($sql78) //2 ♥ 직업 2차
$wr_79 = "$hope123_job1|$hope123_job2";
$sql79 = "update $write_table set wr_79 = '$wr_79' where wr_id = '$wr_id'";
sql_query($sql79) //2 ♥ 직업 3차
$wr_80 = "$hope130";
$sql80 = "update $write_table set wr_80 = '$wr_80' where wr_id = '$wr_id'";
sql_query($sql80) // ♥ 연소득
$wr_81 = "$hope150";
$sql81 = "update $write_table set wr_81 = '$wr_81' where wr_id = '$wr_id'";
sql_query($sql81) // ♥ 주거형태
$wr_82 = "$hope160";
$sql82 = "update $write_table set wr_82 = '$wr_82' where wr_id = '$wr_id'";
sql_query($sql82) // ♥ 주거소유
$wr_83 = "$hope170";
$sql83 = "update $write_table set wr_83 = '$wr_83' where wr_id = '$wr_id'";
sql_query($sql83) // ♥ 승용차소유
$wr_84 = "$hope180";
$sql84 = "update $write_table set wr_84 = '$wr_84' where wr_id = '$wr_id'";
sql_query($sql84) // ♥ 첫인상
$wr_85 = "$hope190";
$sql85 = "update $write_table set wr_85 = '$wr_85' where wr_id = '$wr_id'";
sql_query($sql85) // ♥ 성격
$wr_86 = "$hope200";
$sql86 = "update $write_table set wr_86 = '$wr_86' where wr_id = '$wr_id'";
sql_query($sql86) // ♥ 특기
$wr_87 = "$hope210";
$sql87 = "update $write_table set wr_87 = '$wr_87' where wr_id = '$wr_id'";
sql_query($sql87) // ♥ 취미
$wr_88 = "$hope220";
$sql88 = "update $write_table set wr_88 = '$wr_88' where wr_id = '$wr_id'";
sql_query($sql88) // ♥ 상대혼인경력
$wr_89 = "$hope230";
$sql89 = "update $write_table set wr_89 = '$wr_89' where wr_id = '$wr_id'";
sql_query($sql89) // ♥ 배우자선택기준 (txt)
$wr_90 = "$hope240";
$sql90 = "update $write_table set wr_90 = '$wr_90' where wr_id = '$wr_id'";
sql_query($sql90) // ♥ 나의이상형 (txt)
}
?>
댓글 전체

와 진짜 어렵게 쓰셨네요.
등록폼이 너무 많아 테스트 안해봤는데 우선 소스정리부터 하셔야 될꺼 같습니다.
위처럼 적으시면 sql_query 를 너무 많이 부르니까
if($wr_01 == ""){$wr_01 = "Y";} //승인유무("Y"자동승인)
$sql01= "update $write_table set wr_1 = '$wr_01' where wr_id = '$wr_id'";
sql_query($sql01);
$wr_02 = "$mg010";
$sql02 = "update $write_table set wr_2 = '$wr_02' where wr_id = '$wr_id'";
sql_query($sql02) // ♧ 담당 매니저 코드
$wr_03 = "mg020";
$sql03 = "update $write_table set wr_3 = '$wr_03' where wr_id = '$wr_id'";
sql_query($sql03) // ♧ 담당 매니저
이런식으로 된것을
if($wr_01 == ""){$wr_01 = "Y";} //승인유무("Y"자동승인)
$wr_02 = "$mg010";
$wr_03 = "mg020";
$sql = "update $write_table set wr_1 = '$wr_01' ,wr_2 = '$wr_02' ,wr_3 = '$wr_03' where wr_id = '$wr_id'";
sql_query($sql) ;
이런식으로 바꾸세요..
등록폼이 너무 많아 테스트 안해봤는데 우선 소스정리부터 하셔야 될꺼 같습니다.
위처럼 적으시면 sql_query 를 너무 많이 부르니까
if($wr_01 == ""){$wr_01 = "Y";} //승인유무("Y"자동승인)
$sql01= "update $write_table set wr_1 = '$wr_01' where wr_id = '$wr_id'";
sql_query($sql01);
$wr_02 = "$mg010";
$sql02 = "update $write_table set wr_2 = '$wr_02' where wr_id = '$wr_id'";
sql_query($sql02) // ♧ 담당 매니저 코드
$wr_03 = "mg020";
$sql03 = "update $write_table set wr_3 = '$wr_03' where wr_id = '$wr_id'";
sql_query($sql03) // ♧ 담당 매니저
이런식으로 된것을
if($wr_01 == ""){$wr_01 = "Y";} //승인유무("Y"자동승인)
$wr_02 = "$mg010";
$wr_03 = "mg020";
$sql = "update $write_table set wr_1 = '$wr_01' ,wr_2 = '$wr_02' ,wr_3 = '$wr_03' where wr_id = '$wr_id'";
sql_query($sql) ;
이런식으로 바꾸세요..

오~~~~~ 감사 감사... 쿼리문이 많아서 그런듯 하네요 ㄳㄳ OTL....

진작에 바꿀걸....
설마설마 했었는데 다시수정할 노가다 귀찮아서 머뭇거리고 있었는데..
알고 나니 역시 기초의 중요함이 느껴 집니다.
설마설마 했었는데 다시수정할 노가다 귀찮아서 머뭇거리고 있었는데..
알고 나니 역시 기초의 중요함이 느껴 집니다.