두개의 DB연동? 채택완료

</p>

<p><?</p>

<p>$que = sql_query("SELECT * FROM g5_write_AAA ORDER BY wr_id DESC"); </p>

<p> </p>

<p>$edu_time = sql_fetch(" select count(*) as cnt from g5_write_BBB where wr_14 = '교육신청' and wr_1 in('2018', '2019') and mb_id in (select mb_id from g5_write_AAA)"); //2018~2019년 교육신청 횟수</p>

<p> </p>

<p>$edu_tot = sql_fetch("select sum(wr_13) as wr_13_sum from g5_write_rbosu_55 where wr_16 in('이수', '수료') and Year(wr_2) in('2018', 2019') and mb_id in (select mb_id from g5_write_AAA)"); //교육 이수시간의 합</p>

<p>?></p>

<p> </p>

<p>    <table width="100%" border="1">

    <tr><td colspan="6" ><h4><b>■ 자격취득현황</b></h4></td></tr>

      <tr align='center' height="40">

        <td width="90">이름</td>

        <td width="90">ID</td>

        <td width="90">연락처</td>    

        <td width="90">이메일</td>    

        <td width="90">교육신청횟수</td>

        <td width="90">교육시간</td>

       </tr></p>

<p><?

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

$wr_data = apms_unpack($row['wr_content']);</p>

<p>?>

      <tr align="center" height="40">

        <td><?php echo $row['wr_name']; ?></b></td>

        <td><?php echo $row['mb_id']; ?></td>

        <td><?php echo $wr_data['tel']; ?></td>

        <td><?php echo $wr_data['email']; ?></td></p>

<p>        <td><?php echo $edu_time; ?></td>

        <td><?php echo $edu_tot; ?></td>

      </tr>

<?

}

?></p>

<p>