sy_batch_month; $sql = "select count(*) from t_base_data where bd_auto_commit=3 and bd_month=" . sql_date($month); $commit = db_fetch1($sql); $order_by = order_by(6, 1, 'mb_id', 'mb_name1 || mb_name2', 'mb_mail_addr','mb_zip','mb_area_cd','mb_regist_date', 'bd_auto_commit'); $sql = "select mb_seq_no,mb_id,mb_name1,mb_name2,mb_mail_addr,mb_zip,mb_area_cd,mb_address,mb_regist_date, bd_auto_commit" . " from t_member left join t_base_data on mb_seq_no=bd_mb_seq_no and bd_month=" . sql_date($month) . " where mb_step=3 $order_by"; $result = db_exec($sql); $nrow = pg_numrows($result); ?> <?=$g_title?>
■本登録会員一覧　（総数: 名/当月完了者: 名）
> >
width="100%" class="small">
mb_id)?> mb_name1 $fetch->mb_name2")?> mb_mail_addr)?> mb_zip,0,3)?>-mb_zip,3,4)?> mb_area_cd))?> mb_regist_date))?> bd_auto_commit==3?'*':''?>