답변 2개 / 댓글 4개
채택된 답변
+20 포인트
select sum(cnt) cnt from (
select count(wr_1) cnt from g5_write_01 where wr_1 is not null and wr_1 != ''
union all
select count(wr_1) cnt from g5_write_02 where wr_1 is not null and wr_1 != ''
) x
답변에 대한 댓글 4개
안돼네요 ㅠㅠㅠㅠ
[code]
$sql3 = sql_query("select sum(recomcount) cnt from (
SELECT count(wr_3) AS recomcount FROM g5_write_table GROUP BY wr_3 HAVING count(*) > 1
union all
SELECT count(wr_3) AS recomcount FROM g5_write_table2 GROUP BY wr_3 HAVING count(*) > 1
) x");
<ul>
<?php while($row3= sql_fetch_array($sql3)) { ?>
<li>
<span>이름 : <?php echo $row3["wr_3"]; ?></span>,
<span>전화번호 : <?php echo $row3["cnt"]; ?></span>,
<span>중복수 : <?php echo $row3['recomcount']?></span>
</li>
<?php } ?>
</ul>
[/code]
다했지만 안되네요 ㅠㅠ
[code]
$sql3 = sql_query("select sum(recomcount) cnt from (
SELECT count(wr_3) AS recomcount FROM g5_write_table GROUP BY wr_3 HAVING count(*) > 1
union all
SELECT count(wr_3) AS recomcount FROM g5_write_table2 GROUP BY wr_3 HAVING count(*) > 1
) x");
<ul>
<?php while($row3= sql_fetch_array($sql3)) { ?>
<li>
<span>이름 : <?php echo $row3["wr_3"]; ?></span>,
<span>전화번호 : <?php echo $row3["cnt"]; ?></span>,
<span>중복수 : <?php echo $row3['recomcount']?></span>
</li>
<?php } ?>
</ul>
[/code]
다했지만 안되네요 ㅠㅠ
답변을 작성하려면 로그인이 필요합니다.
$sql2 = sql_query("select sum(cnt) cnt from (
SELECT count(wr_3) AS recomcount FROM g5_write_table GROUP BY wr_3 HAVING count(*) > 1
union all
SELECT count(wr_3) AS recomcount FROM g5_write_table2 GROUP BY wr_3 HAVING count(*) > 1
) x");
<ul>
<?php while($row2= sql_fetch_array($sql2)) { ?>
<li>
<span>전화번호 : <?php echo $row2["wr_3"]; ?></span>,
<span> 추천수 : <?php echo $row2['recomecount']?></span>
</li>
<?php } ?>
</ul>
[/code]
이렇게 중복된 db 와 중복된 수를 뽑아야 하는데 ㅠㅠㅠ 아무것도 나오지가 않네요...