getMessage();
$db->getDebugInfo();
die("connect error");
}
//データを取得
//$sql = "SELECT * from doctors order by family_name_e";
$sql = "SELECT pr_name_e,shozoku_e,sname from program where interid is not null group by pr_name_e,shozoku_e,sname order by sname";
//$stt = $db->prepare($sql);
$result = $db->getAll($sql,array(),DB_FETCHMODE_ASSOC);
if (DB::isError($result)) {
echo $result->getMessage() . "
";
echo $result->getDebugInfo();
die("
ERROR
");
}
$doctors_data = $result;
foreach($doctors_data as $dkey=>$dval) {
//$doctors_with_link[] = "{$dval['dr_name_e']}
{$dval['shozoku_e']}
";
$doctors_with_link[] = "{$dval['pr_name_e']}
{$dval['shozoku_e']}
";
}
//$o_smarty->assign("doctors_data",$doctors_data);
$o_smarty->assign("doctors_with_link",$doctors_with_link);
$o_smarty->assign('table',array('width="100%" border="0" cellspacing="1" cellpadding="5"'));
$o_smarty->assign('tr',array('align="center" class="back2"'));
$o_smarty->assign('td',array('align="left" valign="top"'));
$o_smarty->display("2006/program/doctors_list.tpl");
exit;
?>