getMessage();
$db->getDebugInfo();
die("connect error");
}
//データを取得
$sql = "SELECT s_day_p,s_time_p,e_time_p,room_e,room_mei,shurui,session_mei,lecture_title,pr_name_e,yakuwari,live1,live2,live3 from program where interid is not null";
$sql .= $cond_sql;
$sql .= " order by s_day_p,s_time_p,e_time_p,room_e,room_mei";
//$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);
$o_smarty->display("2006/program/program_dr.tpl");
exit;
?>