getMessage();
$db->getDebugInfo();
die("connect error");
}
//データを取得
$sql = "SELECT s_day_p,s_time_p,e_time_p,room_e,room_mei,shurui,session_mei,live1,live2,live3 from program where interid is not null";
$sql .= $cond_sql;
$sql .= " group by s_day_p,s_time_p,e_time_p,room_e,room_mei,shurui,session_mei,live1,live2,live3 order by s_day_p,s_time_p,e_time_p,room_e";
//$stt = $db->prepare($sql);
$result = $db->getAll($sql,$cond_val,DB_FETCHMODE_ASSOC);
if (DB::isError($result)) {
echo $result->getMessage() . "
";
echo $result->getDebugInfo();
die("
ERROR
");
}
$program_data = $result;
/*
foreach($session_data as $skey=>$sval) {
echo <<<_SESSIONDATA_
{$sval['s_day_p']}：{$sval['s_time_p']}：{$sval['e_time_p']}：{$sval['room_e']}：{$sval['shurui']}：{$sval['session_mei']}
_SESSIONDATA_;
}
*/
$o_smarty->assign("program_data",$program_data);
/*
if ($_REQUEST['m'] == "ro") {
$o_smarty->display("2006/program/program_room.tpl");
} else if ($_REQUEST['m'] == "shu") {
$o_smarty->display("2006/program/program_shurui.tpl");
} else if ($_REQUEST['m'] == "kub") {
$o_smarty->display("2006/program/program_kubun.tpl");
}
*/
$o_smarty->display("2006/program/program_detail.tpl");
exit;
?>