주문 주적값의 회원별 순위 매기기 채택완료

</strong></p>

<p>for ($i=0; $row=sql_fetch_array($result); $i++) {

?></p>

<p><tr class="<?php echo $bg; ?>">

   <td style="text-align:center; padding:5px 0px; width:20%"><?php echo $row['mb_id']; ?>
<?php echo $row['mb_name']; ?></td></p>

<p>   <td style="text-align:center;">

        <?php

        $sql01 = " select * from {$g5['g5_shop_cart_table']}  where  left(od_id, 8) > '{$start_date}' and left(od_id, 8) < '{$end_date}' and ct_status in ('입금', '준비', '배송', '완료') and ct_recommend = '{$member['mb_id']}' and mb_id = '{$row['mb_id']}' order by ct_id asc ";

        $result01 = sql_query($sql01);

                $aa = 0;</p>

<p>        for ($m=0; $row01=sql_fetch_array($result01); $m++) {

            $result_item01 = sql_fetch( " select * from g5_shop_item where it_id = '{$row01['it_id']}' and it_10 = 'Y' " );</p>

<p>                if($result_item01['it_id']){

                $aa = $aa + $row01['ct_qty'];

                }

        } ?>

    <?php echo $aa?>

   </td></p>

<p></tr></p>

<p><?php

}</p>

<p><strong>