assign("SITE_NAME",SITE_NAME); $fobj = new FormObject("管理:アナウンス情報"); $_GET['id'] = (int)$_GET['id']; $sql = " SELECT m1.news_id, date_format(m1.disp_date,'%Y.%m.%d') as news_date, m1.note, m1.title, m1.news_cate, m1.img FROM ds_news m1 WHERE m1.del_flg = 0 AND news_id = '{$_GET['id']}' "; $sth = $dbMaster->prepare($sql); $result = $dbMaster->execute($sth,array()); if($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) { $tmpl->assign("news_id",$row['news_id']); $tmpl->assign("note",nl2br($row['note'])); $tmpl->assign("news_date",$row['news_date']); $tmpl->assign("title",$row['title']); $tmpl->assign("news_cate",$fobj->getLabelValue("news_cate",$row['news_cate'])); if($row['img'] != "") { $tmpl->assign("img",$row['img']); } } $tmpl->flush(); ?>