(CURRENT_DATE() - INTERVAL 1 DAY) GROUP BY member_serno order by instructor_to desc) inst
on inst.member_serno = member.member_serno
left join instdata t3
on member.member_serno = t3.member_serno and t3.instdata_serno != t3.instdata_id
where instructor_type = 'AFAA' and insts not like '%GEI%'";
$data_array = $sql->sql_exec( $query );
$types = array();
foreach ( $data_array as $data ) {
foreach ( explode( ",", $data['insts'] ) as $insttype ) {
$types[ $insttype ] = '';
}
}
?>
教育指導陣容 TWI
