我想在sql里解决,我把 $query="SELECT m_model,m_code,m_color,m_price,m_sendshop,m_ytime,m_available,m_salespeople,m_bz,id,title FROM zypt_mobile where (m_available='已退' or m_available='退还路上') order by m_available,m_sendshop desc"; 改成 $query="SELECT m_model,m_code,m_color,m_price,m_sendshop,m_ytime,m_available,m_salespeople,m_bz,id,title FROM zypt_mobile where (m_available='已退' or m_available='退还路上') and ttile<>'退还销售' order by m_available,m_sendshop desc"; 以后什么都不显示了~ 可是ttile<>'退还销售'条件下有数据呀
To; sandyuk(冰の沙隆) 当我把 $i=count($sms_yy); 改为 $i=$tol; 以后,就显示出来两页,但是每天显示的还是不全,我想是因为虽然$i的数对了,但是$query还是把所有的数据都读出来了,而当我每次continue;还是多加了一个空行。如果我把$query改成$query="SELECT m_model,m_code,m_color,m_price,m_sendshop,m_ytime,m_available,m_salespeople,m_bz,id,title FROM zypt_mobile where (m_available='已退' or m_available='退还路上') and ttile<>'退还销售' order by m_available,m_sendshop desc"; 以后就什么都不显示了~ 郁闷~~
$i=count($sms_yy);
是在此处:
$i=count($sms_yy);$msgnum=20; // 每页20
$start = $page * $msgnum;
$end = $start + $msgnum;
if ($end > $i) $end=$i;
$totalpage=$i/$msgnum;
$query="SELECT m_model,m_code,m_color,m_price,m_sendshop,m_ytime,m_available,m_salespeople,m_bz,id,title FROM zypt_mobile where (m_available='已退' or m_available='退还路上') order by m_available,m_sendshop desc";
改成
$query="SELECT m_model,m_code,m_color,m_price,m_sendshop,m_ytime,m_available,m_salespeople,m_bz,id,title FROM zypt_mobile where (m_available='已退' or m_available='退还路上') and ttile<>'退还销售' order by m_available,m_sendshop desc"; 以后什么都不显示了~
可是ttile<>'退还销售'条件下有数据呀
当我把
$i=count($sms_yy);
改为
$i=$tol;
以后,就显示出来两页,但是每天显示的还是不全,我想是因为虽然$i的数对了,但是$query还是把所有的数据都读出来了,而当我每次continue;还是多加了一个空行。如果我把$query改成$query="SELECT m_model,m_code,m_color,m_price,m_sendshop,m_ytime,m_available,m_salespeople,m_bz,id,title FROM zypt_mobile where (m_available='已退' or m_available='退还路上') and ttile<>'退还销售' order by m_available,m_sendshop desc"; 以后就什么都不显示了~
郁闷~~
==>
title<>'退还销售'
for ($i=$start; $i<$end; $i++)
{
if($sms_yy[$j][10]!='退还销售')
{
echo "<tr bgcolor=#DAEFFF> ";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][9]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][0]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][2]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][4]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][5]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][6]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][8]."</div></td>";
$h=$h+1;
}
else
{
$j++;
continue;
}}
$sms_yy[] = array(1,10=>"");
$sms_yy[] = array(2,10=>"");
$sms_yy[] = array(3,10=>"");
$sms_yy[] = array(4,10=>"");
$sms_yy[] = array(5,10=>"");
$sms_yy[] = array(6,10=>"");
$sms_yy[] = array(7,10=>"");
$sms_yy[] = array(8,10=>"");
$sms_yy[] = array(9,10=>"");
$sms_yy[] = array(10,10=>"");
$sms_yy[] = array(11,10=>"退还销售");
$sms_yy[] = array(12,10=>"");
$sms_yy[] = array(13,10=>"");
$sms_yy[] = array(14,10=>"");
$sms_yy[] = array(15,10=>"");
$sms_yy[] = array(16,10=>"");
$sms_yy[] = array(17,10=>"");
$sms_yy[] = array(18,10=>"");
$sms_yy[] = array(19,10=>"");
$sms_yy[] = array(20,10=>"");
$sms_yy[] = array(21,10=>"");
$sms_yy[] = array(22,10=>"");
$sms_yy[] = array(23,10=>"");
$sms_yy[] = array(24,10=>"退还销售");
$sms_yy[] = array(25,10=>"");
$sms_yy[] = array(26,10=>"");
$sms_yy[] = array(27,10=>"");
$sms_yy[] = array(28,10=>"");
//-----------------------------
//记手机总数$h=0;//记本页显示数目$nummbile=count($sms_yy);
for ($i=0; $i<$nummbile; $i++) {
if ($sms_yy[$i][10]=='退还销售')
{
continue;
}else{
$tol=$tol+1;
}
}//----------------------------
//翻页显示if ($QUERY_STRING!="") {
$page = $QUERY_STRING;
} else {
$page = 0;
} $i=count($sms_yy);$msgnum=20; // 每页20
$start = $page * $msgnum;
$end = $start + $msgnum;
if ($end > $i) $end=$i;
$totalpage=$i/$msgnum; $pagestr="";
if ($page>0) $pagestr=$pagestr."<a href=?".($page-1)."><上页</a> - ";
$pagestr=$pagestr."[第 ";
for ($i=0; $i<$totalpage; $i++) {
if ($i!=$page) {
$pagestr = $pagestr."<a href=?$i>".($i+1)."</a> ";
} else {
$pagestr = $pagestr.($i+1)." ";
}
}
$pagestr=$pagestr." 页] ";
if ($page<($totalpage-1)) $pagestr=$pagestr."- <a href=tuitest.php?".($page+1).">下页></a> "; $pagestr="<div align=center>$pagestr</div>";
//-----------------------------------------------echo "<table width=100% border=0 cellspacing=1 cellpadding=1 >";
echo "<tr bgcolor=#46ADFF>" ;
echo "<td height=28 class=unnamed1 width=9%><div align=center>ID</div></td>";
echo "<td height=28 class=unnamed1 width=9%><div align=center>型号</div></td>";
echo "<td height=28 class=unnamed1 width=9%><div align=center>颜色</div></td>";
echo "<td height=28 class=unnamed1 width=9%><div align=center>退货部门</div></td>";
echo "<td height=28 class=unnamed1 width=9%><div align=center>退货时间</div></td>";
echo "<td height=28 class=unnamed1 width=9%><div align=center>状态</div></td>";
echo "<td height=28 class=unnamed1 width=9%><div align=center>备注</div></td>";
echo "</tr>";
for ($i=$start; $i<$end; $i++)
{
if($sms_yy[$i][10]!='退还销售')
{
echo "<tr bgcolor=#DAEFFF> ";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][9]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][0]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][2]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][4]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][5]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][6]."</div></td>";
echo "<td height=15 class=unnamed width=9%><div align=center>".$sms_yy[$i][8]."</div></td>";
$h=$h+1;
}
else
{
continue;
}}
echo "</tr>";
echo "</table>";
echo "<p>".$pagestr." 共有手机".$tol."部,该页显示手机".$h."部<hr><p>\n"; ?></body>
</html>
<?
exit;
?>
j++ 做什么用呢
to: xuzuning(唠叨)
没有错误,那我应该怎么来修正一下呢
可能是数据库部分有问题,你可以在读出数据后先用print_r($sms_yy)输出其内容检查是否符合要求。
//-----------------------------
//记手机总数
建议你用 title<>'退还销售'后面的就不用改了。上面那一段是在查询时不加 title<>'退还销售'
而显示时就要去掉 title=='退还销售';
我用$j 就是想这样,但发现还是达不到效果,还是直接查询时就 title<>'退还销售' 的好。
echo "<pre>";
print_r($sms_yy);
echo "</pre>";其实查看一下源文件不就行了吗?