SIR
목록으로

답변부탁드릴게요.ㅠ 한번만 보고가세요.ㅠ 채택완료

iilruo
프로필 보기이 회원 글보기이 회원의 댓글보기
 11년 전 조회 5,687
답변 2
목록

그누5사용중인데

게시판 그룹에 있는 글을 A_table 게시판에 모을려고 합니다.

어째어째하다가 만든게  모아는 졌는데 문제가 wr_id값을 못찾아요 그래서 원본인파일은 삭제가 되는데

복사한 테이블은 삭제가 안되네요...

write_update.php문에

 $sql = " insert into $write_table
  set    wr_num = '$wr_num',
                     wr_reply = '$wr_reply',
                     wr_comment = 0,
                     ca_name = '$ca_name',
                     wr_option = '$html,$secret,$mail',
                     wr_subject = '$wr_subject',
                     wr_content = '$wr_content',
                     wr_link1 = '$wr_link1',
                     wr_link2 = '$wr_link2',
                     wr_link1_hit = 0,
                     wr_link2_hit = 0,
                     wr_hit = '{$wr_hit}',
                     wr_good = 0,
                     wr_nogood = 0,
                     mb_id = '{$member['mb_id']}',
                     wr_password = '$wr_password',
                     wr_name = '$wr_name',
                     wr_email = '$wr_email',
                     wr_homepage = '$wr_homepage',
                     wr_datetime = '".G5_TIME_YMDHIS."',
                     wr_last = '".G5_TIME_YMDHIS."',
                     wr_ip = '{$_SERVER['REMOTE_ADDR']}',
                     wr_1 = '$wr_1',
                     wr_2 = '$wr_2',
                     wr_3 = '$wr_3',
                     wr_4 = '$wr_4',
                     wr_5 = '$wr_5',
                     wr_6 = '$wr_6',
                     wr_7 = '$wr_7',
                     wr_8 = '$wr_8',
                     wr_9 = '$wr_9',
                     wr_10 = '$wr_10'
      ";
    sql_query($sql);​

$wr_id = mysql_insert_id();//혹시 이아이가 문제의 발달인거같은데 밑에 넣어도 안되요...
  $sql2 = " insert into a_table
             set wr_num = '$wr_num',
                     wr_reply = '$wr_reply',
                     wr_comment = 0,
                     ca_name = '$ca_name',
                     wr_option = '$html,$secret,$mail',
                     wr_subject = '$wr_subject',
                     wr_content = '$wr_content',
                     wr_link1 = '$wr_link1',
                     wr_link2 = '$wr_link2',
                     wr_link1_hit = 0,
                     wr_link2_hit = 0,
                     wr_hit = '{$wr_hit}',
                     wr_good = 0,
                     wr_nogood = 0,
                     mb_id = '{$member['mb_id']}',
                     wr_password = '$wr_password',
                     wr_name = '$wr_name',
                     wr_email = '$wr_email',
                     wr_homepage = '$wr_homepage',
                     wr_datetime = '".G5_TIME_YMDHIS."',
                     wr_last = '".G5_TIME_YMDHIS."',
                     wr_ip = '{$_SERVER['REMOTE_ADDR']}',
                     wr_1 = '$wr_1',
                     wr_2 = '$wr_2',
                     wr_3 = '$wr_3',
                     wr_4 = '$wr_4',
                     wr_5 = '$wr_5',
                     wr_6 = '$wr_6',
                     wr_7 = '$wr_7',
                     wr_8 = '$wr_8',
                     wr_9 = '$wr_9',
                     wr_10 = '$wr_10'
      ";​

if($bo_table == ||$bo_table == 'b_table'||$bo_table == 'c_table'||$bo_table == 'd_table'||$bo_table == 'e_table'){sql_query($sql2);} ​

 

 

이렇게하니 통합은 되더군요 근데 문제는 '작성완료'등록을 하면 글이 없거나 삭제 되었다고 하더군요

아마 wr_id값이 없다는건데....

어딜 수정해야할까요?? 지금 3일째 멘땅에 해딩하는 느낌이에요.ㅠ 

 

#html5 #java #php #그누보드5 #그누보드4

답변 2개

채택된 답변
+20 포인트

wr_id값이 글을 등록한 테이블의 것을 가져 오게 되는데 이것을 넘기니 없다고 나올수 밖에 없습니다.

 

먼저 특정게시판에 작성을 하고 본인테이블에 작성 

순서를 위아래 바꿔보세요..

 

그렇게 되며 등록후 자신의 테이블로 돌아 오게 될겁니다. 

로그인 후 평가할 수 있습니다

답변에 대한 댓글 1개

음....... 순서를 바꾸어서
$sql2 = " insert into g5_write_total
set
wr_num = '$wr_num',
wr_reply = '$wr_reply',
wr_comment = 0,
ca_name = '$ca_name',
wr_option = '$html,$secret,$mail',
wr_subject = '$wr_subject',
wr_content = '$wr_content',
wr_link1 = '$wr_link1',
wr_link2 = '$wr_link2',
wr_link1_hit = 0,
wr_link2_hit = 0,
wr_hit = '{$wr_hit}',
wr_good = 0,
wr_nogood = 0,
mb_id = '{$member['mb_id']}',
wr_password = '$wr_password',
wr_name = '$wr_name',
wr_email = '$wr_email',
wr_homepage = '$wr_homepage',
wr_datetime = '".G5_TIME_YMDHIS."',
wr_last = '".G5_TIME_YMDHIS."',
wr_ip = '{$_SERVER['REMOTE_ADDR']}',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10 = '$wr_10'
";

if($bo_table == 'massage1'||$bo_table == 'massage2'||$bo_table == 'massage3'||$bo_table == 'massage4'||$bo_table == 'massage5'){sql_query($sql2);}
$wr_id = mysql_insert_id();

$sql = " insert into $write_table
set
wr_num = '$wr_num',
wr_reply = '$wr_reply',
wr_comment = 0,
ca_name = '$ca_name',
wr_option = '$html,$secret,$mail',
wr_subject = '$wr_subject',
wr_content = '$wr_content',
wr_link1 = '$wr_link1',
wr_link2 = '$wr_link2',
wr_link1_hit = 0,
wr_link2_hit = 0,
wr_hit = '{$wr_hit}',
wr_good = 0,
wr_nogood = 0,
mb_id = '{$member['mb_id']}',
wr_password = '$wr_password',
wr_name = '$wr_name',
wr_email = '$wr_email',
wr_homepage = '$wr_homepage',
wr_datetime = '".G5_TIME_YMDHIS."',
wr_last = '".G5_TIME_YMDHIS."',
wr_ip = '{$_SERVER['REMOTE_ADDR']}',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10 = '$wr_10'
";
sql_query($sql);
했는데도 글이 존재하지 않습니다. 이렇게 떠요.......

댓글을 작성하려면 로그인이 필요합니다.

​   $wr_id = mysql_insert_id(); 이건 맨 아래로 가야지되겟죠
로그인 후 평가할 수 있습니다

답변에 대한 댓글 1개

그렇게해서 삭제버튼을 눌러도 반응을 안해요

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인
🐛 버그신고