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; ?>