두 테이블 비교... 채택완료

<table>

    <colgroup>

        <col width="50px">

        <col width="100px">

        <col width="60px">

        <col width="*">

        <col width="100px">

    </colgroup>

    <thead>

    <tr>

        <th>순위</th>

        <th>총판장</th>

        <th>고객수</th>

        <th>판매품목</th>

        <th>총 판매금액</th>

    </tr>

    </thead>

    <tbody>

    <?

    $write_table = $g5['write_prefix'] . $bo_table;

    $sum_count = "0";

    $sql = "

        select a.mb_id, b.mb_name, group_concat(wr_12 separator '||') wr_12, count(*) as cnt , sum(a.wr_31) as tot

          from g5_write_sell a

                   left outer join {$g5['member_table']} b on a.mb_id = b.mb_id

         where wr_29 between '{$stx1}' and '{$stx2}' and wr_50 like '%{$stx7}%'

         group by a.mb_id, b.mb_name ORDER BY tot DESC

    ";

    $result = sql_query($sql);

    while ($row = sql_fetch_array($result)) {

    $list_name = explode('||',$row['wr_12']);

    sort($list_name);  // 정렬

    $num = array_count_values($list_name);</p>

<p>    $sum_count ++

    ?></p>

<p>    <tr>

        <td class="td_c"><?php echo $sum_count ?>위</td>

        <td class="td_c"><?php echo $row['mb_name'] ?></td>

        <td class="td_c"><?php echo $row['cnt'] ?> 명</td>

        <td class="td">

        <?php foreach( $num as $key => $value ){ ?>

        <?php echo $key; ?>(<?php echo $value?>),

        <?php } ?></td>

        <td class="td_r"><?php echo number_format($row['tot']) ?>원</td>

    </tr>

    <?php } ?>

</table>