동일한 게시판에 같은 제목으로 입력시 원글은 삭제
본문
$sql = " select wr_id from g5_write_TEST02 where wr_subject IN(
select wr_subject from g5_write_TEST02 group by wr_subject HAVING COUNT(*) > 1
) and wr_is_comment = '0' order by wr_datetime desc ";
$result = sql_query($sql);
for($i=0; $row=sql_fetch_array($result); $i++){
if($i > 0)
sql_query(" delete from g5_write_TEST02 where wr_id = '{$row['wr_id']}' ")
}
게시판 TEST01,TEST02 일때는 문구를 어떻게 작성 하면 되는가요 ?
답변 1
// Test01 일때
$sql = " select wr_id from g5_write_TEST01 where wr_subject IN(
select wr_subject from g5_write_TEST01 group by wr_subject HAVING COUNT(*) > 1
) and wr_is_comment = '0' order by wr_datetime desc ";
$result = sql_query($sql);
for($i=0; $row=sql_fetch_array($result); $i++){
if($i > 0)
sql_query(" delete from g5_write_TEST01 where wr_id = '{$row['wr_id']}' ")
}
// Test02 일때
$sql = " select wr_id from g5_write_TEST02 where wr_subject IN(
select wr_subject from g5_write_TEST02 group by wr_subject HAVING COUNT(*) > 1
) and wr_is_comment = '0' order by wr_datetime desc ";
$result = sql_query($sql);
for($i=0; $row=sql_fetch_array($result); $i++){
if($i > 0)
sql_query(" delete from g5_write_TEST02 where wr_id = '{$row['wr_id']}' ")
}
이렇게 테이블명을 수정해서 적용하시면 되십니다.
답변을 작성하시기 전에 로그인 해주세요.