/****************************************************** ' System :Eco-footprint 管理ページ ' Content:会員数検索 '******************************************************/ $top = '../..'; $inc = "$top/inc"; include("$inc/login_check.php"); include("$inc/header.php"); $inc = "$top/../inc"; include("$inc/common.php"); include("$inc/define.php"); include("$inc/database.php"); include("$inc/search.php"); include("$inc/list.php"); include("$inc/decode.php"); include("$inc/format.php"); // セッション処理 session_start(); if (!isset($_SESSION['ss_search'])) system_error("セッションが不正", __FILE__); $search = &$_SESSION['ss_search']; if ($search->age_from || $search->age_to) $item = ",'mb_birthday'"; $select = ",AGE(mb_birthday)"; //メイン処理 set_global('member', '会員情報管理', '会員数検索', BACK_CLOSE); $order_by = order_by(6, 1, 'mb_id', 'mb_name1 || mb_name2', 'mb_mail_addr','mb_zip','mb_area_cd','mb_regist_date'); $sql = "SELECT mb_seq_no,mb_id,mb_name1,mb_name2,mb_mail_addr,mb_zip,mb_area_cd,mb_regist_date FROM t_member WHERE $where $order_by"; $result = db_exec($sql); $nrow = pg_numrows($result); ?>
=htmlspecialchars($fetch->mb_id)?> | =htmlspecialchars("$fetch->mb_name1 $fetch->mb_name2")?> | =htmlspecialchars($fetch->mb_mail_addr)?> | =substr($fetch->mb_zip,0,3)?>-=substr($fetch->mb_zip,3,4)?> | =htmlspecialchars(decode_area($fetch->mb_area_cd)).$fetch->mb_address?> | =htmlspecialchars(format_datetime($fetch->mb_regist_date))?> |