
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $query = $pdo->query("(SELECT long_work_mt.id, long_work_mt.title, long_work_mt.update_date, long_work_mt.index, long_work_ct_rc.title AS icon_title, icon FROM long_work_mt INNER JOIN long_work_ct_rc ON long_work_mt.sub_id=long_work_ct_rc.id WHERE indication_flag='t' AND top_flag='t') UNION (SELECT short_work_mt.id, short_work_mt.title, short_work_mt.update_date, short_work_mt.index, short_work_ct_rc.title AS icon_title, icon FROM short_work_mt INNER JOIN short_work_ct_rc ON short_work_mt.sub_id=short_work_ct_rc.id WHERE indication_flag='t' AND top_flag='t') ORDER BY update_date DESC LIMIT 8"); $datas = $query->fetchAll(PDO::FETCH_ASSOC); for($i = 0; $i < 8; $i++){ $tmp = substr($datas[$i]['update_date'],0,10); $tmp = str_replace("-", '/',$tmp); $datas[$i]['update_date'] = $tmp; } ?>