我想在cha==1的情况下做一个7天前的查询显示，不等于1就是最近一周的。可结果只能第一页正常显示。一点下一页就出问题了。
<?php
<?
/*
消费记录页面
模板文件 templates/avatar/mybill.ihtml
*/
include "../include/checkuser.php";
include "../include/db_connect.php";
include "../include/config.php";
include "../mall/include/getMoney.php";
include "../mall/include/img.php";
include "../include/template.inc";
$MyEmoney = getMyMoney("emoney");
$MyCmoney = getMyMoney("cmoney");
$Mymoney = $MyEmoney + $MyCmoney;
$today =date("Y.m.d", mktime (0,0,0,date("m") ,date("d")-7,date("Y")));
function setValue($pos)
{
global $column, $one_page;
global $menu, $menu1;
$column = 1;
$one_page = 15;
}
function getTail ( $mingximenu)
{
global $u_id, $menu;
global $item_name, $tail;
$tail = "id='$u_id' and (f_gift='B' or f_gift='E' or f_gift='C' or f_gift='D' or f_gift='R' or f_gift='P' or f_gift='A' or (f_gift='S' and emoney >0))";
}
function getTotalItem ($mingximenu)
{
global $tb_log, $tail,$tb_gift;
global $item_name, $column;
getTail ($mingximenu);
if($cha==1)
{
$query = "select count(*) from $tb_log where $tail and date<='$today'";
}
else
{
$query = "select count(*) from $tb_log where $tail and date>='$today'";
}
$result = mysql_query ($query);
list ($total) = mysql_fetch_array ($result);
return $total;
}
setValue ("have");
if (!$mingximenu)
{
$mingximenu=0;
}
function setmingxiSubMenu ()
{
global $url_img,$file_server;
global $mingxi_menu;
global $mingximenu;
$html = "";
$html .= "
\r\n";
for ($i=0; $i <= 2; $i++)
{
if ($i== $mingximenu)
{
if($i == 0)
{
$html .= " \r\n";
return $html;
}
$Mymoney = getMyMoney("total");
if(!$Mymoney){
$Mymoney = 0;
}
$query="select sum(emoney)+sum(cmoney) from tb_log_basket where id='$u_id' and (f_gift='B' or f_gift='S') ";
$result = mysql_query ($query);
list ($totalxiaofei) = @mysql_fetch_array ($result);
if(!$totalxiaofei)
{
$totalxiaofei = 0;
}
if ($mingximenu==0 )
{
$bgimgcolor="mingxi1_01.gif";
$bgimgcolor1= "mingxi1_02.gif";
$color="#E1EEFF";
}
if ($mingximenu==1 )
{
$bgimgcolor="mingxi1_01.gif";
$bgimgcolor1= "mingxi1_02.gif";
$color="#E1EEFF";
}
if ($mingximenu==2 )
{
$bgimgcolor="mingxi1_01.gif";
$bgimgcolor1= "mingxi1_02.gif";
$color="#E1EEFF";
}
$total = getTotalItem ( $mingximenu );
$t = new Template("../templates/avatar", "keep");
$t->set_file("indexok" , "mybill.ihtml");
$t->set_var(array
("9youtitle"=>$title,
"file_server"=>$file_server,
"url_img"=>$url_img,
"menu"=>$menu,
"mall_sex"=>$mall_sex,
"file_logout"=>$file_logout,
"data"=>$data,
"u_sex"=>$u_sex,
"seximg"=>$seximg,
"u_name"=>$u_name,
"sendmoney"=>$sendmoney,
"facehtml"=>$face_html,
"mingximenu"=>$mingximenu,
"u_name"=>$u_name,
"Mymoney"=>$Mymoney,
"totalxiaofei"=>$totalxiaofei,
"bgimgcolor"=>$bgimgcolor,
"bgimgcolor1"=>$bgimgcolor1,
"color"=>$color,
"setmingxiSubMenu"=>setmingxiSubMenu()
)
);
$t->set_block("indexok","mingxidata","mingxidatas");
$t->set_block("indexok","blankline","blanklines");
echo $total;
if ($total > 0)
{
$total_page = ceil ($total / $one_page);
$page = $page < 1 ? 1 : $page;
$page = $page > $total_page ? $total_page : $page;
$start = ($page - 1) * $one_page;
}
if (!$page)
{
$page=1;
}
$end=$one_page*$page;
$t->set_var(array("header1"=>"消费时间",
"header2"=>"消费项目",
"header3"=>"消费金币",
"header4"=>"消费人",
"header5"=>"消费方式",
"header6"=>"获得人",
));
/* $riqi="date<='$today-INTERVAL 7 DAY' ";*/
if($cha==1)
{
$query = "select no,id,date,f_gift,item_name,total_price,rid from $tb_log where $tail and date<='$today' order by no desc limit $start, $one_page";
}
else
{
$query = "select no,id,date,f_gift,item_name,total_price,rid from $tb_log where $tail and date>='$today' order by no desc limit $start, $one_page";
}
$result = mysql_query ($query);
list ($no,$id, $date, $f_gift, $item_name, $money , $rid) = @mysql_fetch_array ($result);
$color=0;
if ($no=="")
{
$empty=" ";
$t->set_var( array(
"data1"=>$empty,
"data2"=>$empty,
"data3"=>$empty,
"data4"=>$empty,
"data5"=>$empty,
"data6"=>$empty
));
$t->parse("mingxidatas", "mingxidata",true);
}
if ($end-$total<=0)
{
$t->parse("blanklines","blankline",true);
}
while($no)
{
if ( $color==0)
{
$t->set_var("linecolor","#FFFFFF");
$color=1;
}
else
{
$t->set_var("linecolor","#F1F1F1");
$color=0;
}
//$item_name=$gift[$f_gift][0].$item_name;
if ($f_gift=='C' || $f_gift=='D') // ////huodong1 增加
{ $money=0; }
else
{ $money=$gift[$f_gift][1].$money; }
$t->set_var(array(
"total"=>$total,
"data1"=>$date,
"data2"=>$item_name,
"data3"=>$money,
"data4"=>$u_name,
"data5"=>$gift[$f_gift][0],
"data6"=>id_to_name($rid))
);
list ($no,$id, $date, $f_gift, $item_name, $money, $rid) =@ mysql_fetch_array ($result);
$t->parse("mingxidatas","mingxidata",true);
}
for ( $i=0;$i< $end-$total;$i++) //空行显示
{
if( $color==0 )
{
$t->set_var("blanklinecolor","#FFFFFF");
$color=1;
}
else
{
$t->set_var("blanklinecolor","#F1F1F1");
$color=0;
}
$t->parse("blanklines","blankline",true);
}
$prev_page = $page - 1;
$next_page = $page + 1;
if ( $prev_page > 0 )
{
$t->set_var("setpage1","上一页 ");
}
else
{
$t->set_var("setpage1","上一页");
}
$optionlist="";
if ( $prev_page > 0 )
{
$t->set_var("first_page","第一页 ");
}
else
{
$t->set_var("first_page","第一页");
}
if ( $prev_page < $total_page-1 )
{
$t->set_var("last_page","最后一页 ");
}
else
{
$t->set_var("last_page","最后一页");
}
//$t->set_var("first_page","上一页 ");
for ($i=1; $i <= $total_page; $i++)
{
if ($i == $page)
$optionlist.="$i ";
else
$optionlist.="$i ";
}
$t->set_var(array("optionlist"=>$optionlist,"total_page"=>$total_page));
if ($next_page <= $total_page)
{
$t->set_var("setpage2","下一页 ");
}
else
{
$t->set_var("setpage2","下一页");
}
$t->parse("out","indexok");
$t->p("out");
?>
?>
订阅该问题
悬赏分：20 - 2007年08月15日
\r\n";
}
if($i == 1)
{
$html .= "
\r\n";
}
if($i == 2)
{
$html .= "
\r\n";
}
}
else
{
if($i == 0)
{
$html .= "
\r\n";
}
if($i == 1)
{
$html .= "
\r\n";
}
if($i == 2)
{
$html .= "
\r\n";
}
}
}
$html .= "