/****************************************************** ' System :Eco-footprint 管理ページ ' Content:会員CD-ROMクリック履歴 '******************************************************/ $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/decode.php"); include("$inc/select.php"); include("$inc/format.php"); include("$inc/list.php"); // ログイン結果選択肢 function select_login_result($sel) { echo ""; echo ""; echo ""; } //メイン処理 set_global('etc', 'その他管理', 'CD-ROMクリック履歴', BACK_TOP); // where条件 if ($date_y != '') and_join($where, 'date_trunc(\'day\',cd_date)=' . sql_date("$date_y/$date_m/$date_d")); if ($ip_addr != '') and_join($where, 'cd_ip_addr LIKE ' . sql_char("%$ip_addr%")); if ($where != '') { $where = "($where)"; $where = "WHERE $where"; } // ソート条件 $order_by = order_by(1, 1, 'cd_date', 'cd_ip_addr'); // 表示行数条件 $limit = disp_limit(); $sql = "SELECT count(cd_ip_addr) as count FROM l_cd_click $where"; $num = db_fetch1($sql); $sql = "SELECT cd_date,cd_ip_addr FROM l_cd_click $where $order_by $limit"; $result = db_exec($sql); $nrow = pg_numrows($result); ?>
=format_datetime($fetch->cd_date)?> | =$fetch->cd_ip_addr?> |