여유필드 update / insert 관련 채택완료
잠시만요
10년 전
조회 4,471
덧글입력에 신청서작성이 필요해서 여유필드를 넉넉하게 wr_30 까지 사용하고 있습니다.
(실제 사용은 wr_20 까지 사용합니다.)
bbs/weite_uodate.php 에서 update 쿼리하고 insert 쿼리문에 wr_10 이후에 아래 소스와 같이 추가해 주었고요.
게시물 작성할때는 DB에 값이 정상적으로 입.출력 됩니다...
그런데 게시물을 복사한 후에 DB를 열어보면 wr_10 까지밖에 복사가 안되네요...
</p><p> $sql = " insert into $write_table</p><p> set wr_num = '$wr_num',</p><p> wr_reply = '$wr_reply',</p><p> wr_comment = 0,</p><p> ca_name = '$ca_name',</p><p> wr_option = '$html,$secret,$mail',</p><p> wr_subject = '$wr_subject',</p><p> wr_content = '$wr_content',</p><p> wr_link1 = '$wr_link1',</p><p> wr_link2 = '$wr_link2',</p><p> wr_link1_hit = 0,</p><p> wr_link2_hit = 0,</p><p> wr_hit = 0,</p><p> wr_good = 0,</p><p> wr_nogood = 0,</p><p> mb_id = '{$member['mb_id']}',</p><p> wr_password = '$wr_password',</p><p> wr_name = '$wr_name',</p><p> wr_email = '$wr_email',</p><p> wr_homepage = '$wr_homepage',</p><p> wr_datetime = '".G5_TIME_YMDHIS."',</p><p> wr_last = '".G5_TIME_YMDHIS."',</p><p> wr_ip = '{$_SERVER['REMOTE_ADDR']}',</p><p> wr_1 = '$wr_1',</p><p> wr_2 = '$wr_2',</p><p> wr_3 = '$wr_3',</p><p> wr_4 = '$wr_4',</p><p> wr_5 = '$wr_5',</p><p> wr_6 = '$wr_6',</p><p> wr_7 = '$wr_7',</p><p> wr_8 = '$wr_8',</p><p> wr_9 = '$wr_9',</p><p> wr_10 = '$wr_10',</p><p> wr_11 = '$wr_11',</p><p> wr_12 = '$wr_12',</p><p> wr_13 = '$wr_13',</p><p> wr_14 = '$wr_14',</p><p> wr_15 = '$wr_15',</p><p> wr_16 = '$wr_16',</p><p> wr_17 = '$wr_17',</p><p> wr_18 = '$wr_18',</p><p> wr_19 = '$wr_19',</p><p> wr_20 = '$wr_20',</p><p> wr_21 = '$wr_21',</p><p> wr_22 = '$wr_22',</p><p> wr_23 = '$wr_23',</p><p> wr_24 = '$wr_24',</p><p> wr_25 = '$wr_25',</p><p> wr_26 = '$wr_26',</p><p> wr_27 = '$wr_27',</p><p> wr_28 = '$wr_28',</p><p> wr_29 = '$wr_29',</p><p> wr_30 = '$wr_30' ";</p><p> sql_query($sql); </p><p> </p><p>===================================</p><p> </p><p> $sql = " update {$write_table}</p><p> set ca_name = '{$ca_name}',</p><p> wr_option = '{$html},{$secret},{$mail}',</p><p> wr_subject = '{$wr_subject}',</p><p> wr_content = '{$wr_content}',</p><p> wr_link1 = '{$wr_link1}',</p><p> wr_link2 = '{$wr_link2}',</p><p> mb_id = '{$mb_id}',</p><p> wr_name = '{$wr_name}',</p><p> wr_email = '{$wr_email}',</p><p> wr_homepage = '{$wr_homepage}',</p><p> wr_1 = '{$wr_1}',</p><p> wr_2 = '{$wr_2}',</p><p> wr_3 = '{$wr_3}',</p><p> wr_4 = '{$wr_4}',</p><p> wr_5 = '{$wr_5}',</p><p> wr_6 = '{$wr_6}',</p><p> wr_7 = '{$wr_7}',</p><p> wr_8 = '{$wr_8}',</p><p> wr_9 = '{$wr_9}',</p><p> wr_10 = '{$wr_10}',</p><p> wr_11 = '{$wr_11}',</p><p> wr_12 = '{$wr_12}',</p><p> wr_13 = '{$wr_13}',</p><p> wr_14 = '{$wr_14}',</p><p> wr_15 = '{$wr_15}',</p><p> wr_16 = '{$wr_16}',</p><p> wr_17 = '{$wr_17}',</p><p> wr_18 = '{$wr_18}',</p><p> wr_19 = '{$wr_19}',</p><p> wr_20 = '{$wr_20}',</p><p> wr_21 = '{$wr_21}',</p><p> wr_22 = '{$wr_22}',</p><p> wr_23 = '{$wr_23}',</p><p> wr_24 = '{$wr_24}',</p><p> wr_25 = '{$wr_25}',</p><p> wr_26 = '{$wr_26}',</p><p> wr_27 = '{$wr_27}',</p><p> wr_28 = '{$wr_28}',</p><p> wr_29 = '{$wr_29}',</p><p> wr_30= '{$wr_30}'</p><p> {$sql_ip}</p><p> {$sql_password}</p><p> where wr_id = '{$wr['wr_id']}' ";</p><p> sql_query($sql); </p><p> </p><p>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인
해결했습니다. 감사합니다.