require_once "header.html";
//상담디비 과목정보
$sql = "SELECT wm_id, wm_title, wm_title_en, wm_id, wm_business_code, wm_intro, wm_usage_ag_code
FROM sp_lecture
WHERE wm_status = 'Y'
AND wm_business_code IN ('B0001','B0002')
AND wm_lec_type IN ('B','F')
AND length(wm_intro) > 1
ORDER BY RAND() LIMIT 0,10";
$cdata = $db->getFetchQueryAll($sql);
?>
$tb_code = substr($_TB['b_news'],6);
$sql = "SELECT b.wm_id, b.wm_title, b.wm_wdate, b.wm_content, b.wm_1, s.wm_new_icon FROM ".$_TB['b_news']." as b left join ".$_TB['board_set']." as s on s.wm_table='".$_TB['b_news']."' WHERE b.wm_notice = 'Y' AND b.is_del = 'N' ORDER BY b.wm_id DESC LIMIT 4";
$news = $mga_db->getFetchQueryAll($sql);
?>
메가스터디 아카데미 News
foreach($news as $v){
$file_sql = "SELECT * FROM ".$_TB['board_file']." WHERE wm_table = '".$tb_code."' AND wm_bid = '".$v['wm_id']."'";
$fi = $mga_db->getFetchQuery($file_sql);
$fpath = RFU.'/board/'.$tb_code."/";
$img = $fpath.$fi['wm_filename'];
?>