동일한 게시판에 같은 제목으로 입력시 원글은 삭제 채택완료

</p>

<p>// Test01 일때</p>

<p>$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']}' ")

}</p>

<p> </p>

<p>// Test02 일때</p>

<p>$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']}' ")

}</p>

<p>