ccid), emem_num, euid, e_type, e_ival, e_oval, e_date order_point
/*
$query_Rt2 = sprintf("SELECT a.*,b.rdoc,c.mem_auto,d.p_title FROM order_point as a, order_rtype as b ,order_datas as c,product_data as d WHERE a.e_type=b.rid AND a.eccid=c.ccid AND c.mem_auto=d.mem_auto AND a.euid='%s' ORDER BY a.eid DESC",$_SESSION['login_memid']);
*/
$query_Rt2 = sprintf("SELECT a.*,b.rdoc FROM order_point as a, order_rtype as b WHERE a.e_type=b.rid AND a.euid='%s' ORDER BY a.eid DESC",$_SESSION['login_memid']);
$query_limit_Rt2 = sprintf("%s LIMIT %d, %d", $query_Rt2, $startRow_Rt2, $maxRows_Rt2);
$Rt2 = mysql_query($query_limit_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
if (isset($_GET['totalRows_Rt2'])) {
$totalRows_Rt2 = $_GET['totalRows_Rt2'];
} else {
$all_Rt2 = mysql_query($query_Rt2);
$totalRows_Rt2 = mysql_num_rows($all_Rt2);
}
$totalPages_Rt2 = ceil($totalRows_Rt2/$maxRows_Rt2)-1;
$queryString_Rt2 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Rt2") == false &&
stristr($param, "menu") == false &&
stristr($param, "totalRows_Rt2") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Rt2 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Rt2 = sprintf("&totalRows_Rt2=%d%s", $totalRows_Rt2, $queryString_Rt2);
mysql_select_db($database_BE2, $BE2);
$query_Rt3 = sprintf("SELECT sum(if(e_flag='N',e_ival,0)) AS e_i, sum(if(e_flag='Y',e_ival,0)) as e_u FROM order_point WHERE euid='%s' group by euid ",$_SESSION['login_memid']);
$Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
$row_Rt3 = mysql_fetch_assoc($Rt3);
?>