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'
ORDER BY update_date DESC
LIMIT 8" );
$long_datas = $sql_long->fetchAll(PDO::FETCH_ASSOC);
//print_r($long_datas);
$sql_short = $pdo->query("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");
$short_datas = $sql_short->fetchAll(PDO::FETCH_ASSOC);
for($i = 0; $i < 8; $i++){
$tmp = substr($long_datas[$i]['update_date'],0,10);
$tmp = str_replace("-", '/',$tmp);
$long_datas[$i]['update_date'] = $tmp;
$tmp = substr($short_datas[$i]['update_date'],0,10);
$tmp = str_replace("-", '/',$tmp);
$short_datas[$i]['update_date'] = $tmp;
}
?>
