그룹에 속한 게시판링크를 출력하는 sql문 채택완료

</p>

<p><?php

// 그룹명

$gr_id = 'exo';</p>

<p>// 게시판정보 변수선언

$board_info = array();</p>

<p>// 쿼리문

$sql = "select bo_table, bo_subject from {$g5['board_table']} where gr_id = '{$gr_id}' order by bo_subject asc";

$result = sql_query($sql, false);

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

    $board_info[$i] = $row;

}

?></p>

<p><?php if (count($board_info) > 0) { ?>

<ul>

    <?php foreach ($board_info as $info) { ?>

    <li><a href="<?php echo G5_BBS_URL; ?>/barod.php?bo_table=<?php echo $info['bo_table']; ?>"><?php echo $info['bo_subject']; ?></a></li>

    <?php } ?>

</ul>

<?php } ?></p>

<p>

</p>

<p><?php

// 게시판정보 변수선언

$board_all_info = array();</p>

<p>// 추출 필드명

$fields = 'bo.bo_table, bo.bo_subject, gr.gr_id, gr.gr_subject';</p>

<p>// 정렬

$orderby = ' order by gr.gr_subject asc, bo.bo_subject asc ';</p>

<p>// 쿼리문

$sql = "select {$fields} from {$g5['board_table']} as bo left join {$g5['group_table']} as gr on bo.gr_id = gr.gr_id where (1) {$orderby} ";

$result = sql_query($sql, false);

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

    $board_all_info[$row['gr_id']]['board_info'][$i] = $row;

    $board_all_info[$row['gr_id']]['gr_subject'] = $row['gr_subject'];

}

?></p>

<p><?php if (count($board_all_info) > 0) { ?>

    <?php foreach ($board_all_info as $group_info) { ?>

    <h3>그룹 : <?php echo $group_info['gr_subject']; ?></h3>

    <div>

        <?php if (count($group_info['board_info']) > 0) { ?>

        <ul>

            <?php foreach ($group_info['board_info'] as $info) { ?>

            <li><a href="<?php echo G5_BBS_URL; ?>/barod.php?bo_table=<?php echo $info['bo_table']; ?>"><?php echo $info['bo_subject']; ?></a></li>

            <?php } ?>

        </ul>

        <?php } ?>

    </div>

    <hr>

    <?php } ?>

<?php } ?></p>

<p>