$sql="select * from sq_class where 1=1 ".$strq." order by class_id asc limit $firstcount, $displaypg";我把排离改为ASC时,刚才我试了一下,ID为5000以上时排序出错,为:5241 5242 5240 5239 5237 5238而5000以下,的ID产品排序正常
全文 <?php if(empty($_GET['Bid'])&&empty($_GET['Sid'])&&empty($_GET['Tid'])) { $strq=" "; }else if($_GET['Tid']!="") { $strq=" and sortid=".$_GET['Tid'].""; } else if($_GET['Sid']!="") { $strq=" and (sortid=".$_GET['Sid']." or sortid in(select sortid from sql_sys_sort where sort_fsid=".$_GET['Sid']."))"; } else{ $strq=" and (sortid in(select sortid from sql_sys_sort where sort_fsid=".$_GET['Bid'].") or sortid=".$_GET['Bid'].")"; } $sql="select * from sq_class where 1=1 ".$strq; $total=mysql_num_rows(mysql_query($sql,$conn)); if($_GET['saixiuan']!="") { $displaypg=$_GET['saixiuan']; }
else{ $displaypg=18; } pageft($total,$displaypg,"Products.php?Bid=".$_GET['Bid']."&Sid=".$_GET['Sid']."&Tid=".$_GET['Tid']."&saixiuan=".$_GET['saixiuan']."&picejia=".$_GET['picejia'].""); $page=$_REQUEST["page"]; if(empty($page)) $page=1; $firstcount=($page-1)*$displaypg; if($_GET['picejia']!=0) { $sql="select * from sq_class where 1=1 ".$strq." order by price desc limit $firstcount, $displaypg"; }
else if($_GET['picejia']!=1){ $sql="select * from sq_class where 1=1 ".$strq." order by price asc limit $firstcount, $displaypg"; }else{ $sql="select * from sq_class where 1=1 ".$strq." order by class_id asc limit $firstcount, $displaypg"; } //echo $sql; $result=$db->query($sql,$conn); $row=$db->num_rows($result); for ($i=0;$i<$row;$i++){ $rs=$db->fetch_array($result,MYSQL_BOTH); ?>
if($_GET['saixiuan']!="") {
$displaypg=$_GET['saixiuan'];
}
else{ $displaypg=18; }
pageft($total,$displaypg,"Products.php?Bid=".$_GET['Bid']."&Sid=".$_GET['Sid']."&Tid=".$_GET['Tid']."&saixiuan=".$_GET['saixiuan']."&picejia=".$_GET['picejia'].""); $page=$_REQUEST["page"]; if(empty($page)) $page=1; $firstcount=($page-1)*$displaypg;
if($_GET['picejia']!=0) {
$sql="select * from sq_class where 1=1 ".$strq." order by price desc limit $firstcount, $displaypg";
}
else if($_GET['picejia']!=1){ $sql="select * from sq_class where 1=1 ".$strq." order by price asc limit $firstcount, $displaypg"; }else{ $sql="select * from sq_class where 1=1 ".$strq." order by class_id asc limit $firstcount, $displaypg"; }
//echo $sql; $result=$db->query($sql,$conn); $row=$db->num_rows($result); for ($i=0;$i<$row;$i++){ $rs=$db->fetch_array($result,MYSQL_BOTH); ?>
//任何值,要同时满足 == 0 , == 1 才能执行到最后的elseif($_GET['picejia']!=0)
{
echo 'A';
}
else if($_GET['picejia']!=1)
{
echo 'B';
}
else
{
echo 'C';//这样子C是打印不出来的
}
if($_GET['picejia']==='0')
{
echo 'A';
}
else if($_GET['picejia']==='1')
{
echo 'B';
}
else if($_GET['picejia']==='')
{
echo 'C';
}