한개의 게시판에 글을 올리면 다른 게시판에 동시에 등록되도록 하고 싶어요 채택완료
update문에 board명만 추가 해주면 될 것같은데 (삭제 수정도 마찬가지로요 ) 제가 php를 잘 몰라서 자꾸 에러가 나네요. 조언 좀 부탁드립니다
</strong>$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> sql_query($sql);</p><p><strong style="color: rgb(127, 127, 127); font-family: 돋움, Dotum, sans-serif; font-size: 12px; letter-spacing: -0.01px; line-height: normal;">
여기서 </strong></p><p>if($write_table==dino){</p><p style="font-size: 14.6667px;">$sql = " insert into 'dino_A'</p><p style="font-size: 14.6667px;"> set wr_num = '$wr_num',</p><p style="font-size: 14.6667px;"> wr_reply = '$wr_reply',</p><p style="font-size: 14.6667px;"> wr_comment = 0,</p><p style="font-size: 14.6667px;"> ca_name = '$ca_name',</p><p style="font-size: 14.6667px;"> wr_option = '$html,$secret,$mail',</p><p style="font-size: 14.6667px;"> wr_subject = '$wr_subject',</p><p style="font-size: 14.6667px;"> wr_content = '$wr_content',</p><p style="font-size: 14.6667px;"> wr_link1 = '$wr_link1',</p><p style="font-size: 14.6667px;"> wr_link2 = '$wr_link2',</p><p style="font-size: 14.6667px;"> wr_link1_hit = 0,</p><p style="font-size: 14.6667px;"> wr_link2_hit = 0,</p><p style="font-size: 14.6667px;"> wr_hit = 0,</p><p style="font-size: 14.6667px;"> wr_good = 0,</p><p style="font-size: 14.6667px;"> wr_nogood = 0,</p><p style="font-size: 14.6667px;"> mb_id = '{$member['mb_id']}',</p><p style="font-size: 14.6667px;"> wr_password = '$wr_password',</p><p style="font-size: 14.6667px;"> wr_name = '$wr_name',</p><p style="font-size: 14.6667px;"> wr_email = '$wr_email',</p><p style="font-size: 14.6667px;"> wr_homepage = '$wr_homepage',</p><p style="font-size: 14.6667px;"> wr_datetime = '".G5_TIME_YMDHIS."',</p><p style="font-size: 14.6667px;"> wr_last = '".G5_TIME_YMDHIS."',</p><p style="font-size: 14.6667px;"> wr_ip = '{$_SERVER['REMOTE_ADDR']}',</p><p style="font-size: 14.6667px;"> wr_1 = '$wr_1',</p><p style="font-size: 14.6667px;"> wr_2 = '$wr_2',</p><p style="font-size: 14.6667px;"> wr_3 = '$wr_3',</p><p style="font-size: 14.6667px;"> wr_4 = '$wr_4',</p><p style="font-size: 14.6667px;"> wr_5 = '$wr_5',</p><p style="font-size: 14.6667px;"> wr_6 = '$wr_6',</p><p style="font-size: 14.6667px;"> wr_7 = '$wr_7',</p><p style="font-size: 14.6667px;"> wr_8 = '$wr_8',</p><p style="font-size: 14.6667px;"> wr_9 = '$wr_9',</p><p style="font-size: 14.6667px;"> wr_10 = '$wr_10' ";</p><p> </p><p><span style="font-size: 14.6667px;"> sql_query($sql);</span> </p><p style="font-size: 14.6667px;">$sql = " insert into 'dino_B'</p><p style="font-size: 14.6667px;"> set wr_num = '$wr_num',</p><p style="font-size: 14.6667px;"> wr_reply = '$wr_reply',</p><p style="font-size: 14.6667px;"> wr_comment = 0,</p><p style="font-size: 14.6667px;"> ca_name = '$ca_name',</p><p style="font-size: 14.6667px;"> wr_option = '$html,$secret,$mail',</p><p style="font-size: 14.6667px;"> wr_subject = '$wr_subject',</p><p style="font-size: 14.6667px;"> wr_content = '$wr_content',</p><p style="font-size: 14.6667px;"> wr_link1 = '$wr_link1',</p><p style="font-size: 14.6667px;"> wr_link2 = '$wr_link2',</p><p style="font-size: 14.6667px;"> wr_link1_hit = 0,</p><p style="font-size: 14.6667px;"> wr_link2_hit = 0,</p><p style="font-size: 14.6667px;"> wr_hit = 0,</p><p style="font-size: 14.6667px;"> wr_good = 0,</p><p style="font-size: 14.6667px;"> wr_nogood = 0,</p><p style="font-size: 14.6667px;"> mb_id = '{$member['mb_id']}',</p><p style="font-size: 14.6667px;"> wr_password = '$wr_password',</p><p style="font-size: 14.6667px;"> wr_name = '$wr_name',</p><p style="font-size: 14.6667px;"> wr_email = '$wr_email',</p><p style="font-size: 14.6667px;"> wr_homepage = '$wr_homepage',</p><p style="font-size: 14.6667px;"> wr_datetime = '".G5_TIME_YMDHIS."',</p><p style="font-size: 14.6667px;"> wr_last = '".G5_TIME_YMDHIS."',</p><p style="font-size: 14.6667px;"> wr_ip = '{$_SERVER['REMOTE_ADDR']}',</p><p style="font-size: 14.6667px;"> wr_1 = '$wr_1',</p><p style="font-size: 14.6667px;"> wr_2 = '$wr_2',</p><p style="font-size: 14.6667px;"> wr_3 = '$wr_3',</p><p style="font-size: 14.6667px;"> wr_4 = '$wr_4',</p><p style="font-size: 14.6667px;"> wr_5 = '$wr_5',</p><p style="font-size: 14.6667px;"> wr_6 = '$wr_6',</p><p style="font-size: 14.6667px;"> wr_7 = '$wr_7',</p><p style="font-size: 14.6667px;"> wr_8 = '$wr_8',</p><p style="font-size: 14.6667px;"> wr_9 = '$wr_9',</p><p style="font-size: 14.6667px;"> wr_10 = '$wr_10' ";</p><p style="font-size: 14.6667px;"> </p><p style="font-size: 14.6667px;"><span style="font-size: 14.6667px;"> sql_query($sql);</span></p><p style="font-size: 14.6667px;"><span style="font-size: 14.6667px;">
답변 1개
set 문장 이유는 동일하게 하니까 insert는 set문장은 변수로 담아서 처리하시면되구요.
insert문장만 2번 돌리면 쉽게 처리 할수있을듯합니다.
$sql_add = " set set wr_num = '$wr_num', " ...
if( $w == "") // 글등록시
{
$sql = " insert into 'dino_A' . $sql_add
sql_query($sql);
$sql = " insert into 'dino_B' . $sql_add
sql_query($sql);
} else { // 글 수정시
$sql = " update 'dino_A' . $sql_add . 'where wr_id = '$wr_id'"
sql_query($sql);
$sql = " update 'dino_B' . $sql_add . 'where wr_id = '$wr_id'"
sql_query($sql);
}
요런식으로 하심 간편하게 하실듯 생각됩니다.
답변에 대한 댓글 1개
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
write_update.skin.php 에서 위 코드를
1.어느 위치에 넣어야 할지요?
wr_ip = '{$_SERVER['REMOTE_ADDR']}',
여기 밑에 넣으라는 말씀이신지요,,
2.위의 코드는 애러가 있는거 같은데,,무엇이 잘 못되었을지요?