php分页输出问题

类型
账号
店名

这里是 search.php页的
*****************************
这里是searchshow.php 页的
<?php session_start();
?>
<meta charset=”utf-8″>
<?php
include(“conn/conn.php”);
include(“search.php”);

$search=$_POST[search];
$xuanze=$_POST[xuanze];
if($_POST[search]==””){
$search=$_GET[search];
$xuanze=$_GET[xuanze];
}

if(shoptype==”$xuanze”){
$sql1=mysql_query(“select count(*) as total from tb_members where shoptype=’$search’ order by mid”);
}elseif(user==”$xuanze”){
$sql1=mysql_query(“select count(*) as total from tb_members where user=’$search’ order by mid”);
}elseif(shopname==”$xuanze”){
$sql1=mysql_query(“select count(*) as total from tb_members where shopname=’$search’ order by mid”);
}

$minfo=mysql_fetch_array($sql1); //在这里出错
$total=$minfo[total];
$pagesize=5;
if($total<=$pagesize){
$pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==””){
$page=1;
}else{
$page=intval($_GET[page]);
}

if(shoptype==”$xuanze”){
$sql=mysql_query(“select * from tb_members where shoptype=’$search’ order by mid limit “.($page-1)*$pagesize.”,$pagesize”);
}elseif(user==”$xuanze”){
$sql=mysql_query(“select * from tb_members where user=’$search’ order by mid limit “.($page-1)*$pagesize.”,$pagesize”);
}
elseif(shopname==”$xuanze”){
$sql=mysql_query(“select * from tb_members where shopname=’$search’ order by mid limit “.($page-1)*$pagesize.”,$pagesize”);
}

$info=mysql_fetch_array($sql);//在这里也出错
?>

<?php
if($info){
do{ ?>

<?php
}while($info=mysql_fetch_array($sql));
?>

共有
<?php
echo $total;
?>
条 每页显示 <?php echo $pagesize;?> 条 第 <?php echo $page;?> 页/共 <?php echo $pagecount; ?> 页
<?php
if($page>=2){
?>
&search=<?php echo $search;?>&page=1″ title=”首页”>
&search=<?php echo $search;?>&page=<?php echo $page-1;?>” title=”上一页”>
<?php
}
if($pagecount<=4){
for($i=1;$i<=$pagecount;$i++){
?>
&search=<?php echo $search;?>&page=<?php echo $i;?>”><?php echo $i;?>
<?php
}
}else{
for($i=1;$i<=4;$i++){
?>
&search=<?php echo $search;?>&page=<?php echo $i;?>”><?php echo $i;?>
<?php }?>
&search=<?php echo $search;?>&page=<?php echo $page-1;?>” title=”下一页”>
&search=<?php echo $search;?>&page=<?php echo $pagecount;?>” title=”尾页”>
<?php }?>

<?php
}else{
?>
对不起，您检索的信息不存在！
<?php
}mysql_close();

?>

这是出错的地方
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\AppServ\www\shihui\admin\searchshow.php on line 33

Warning:

^{搞gaodaima代码} mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\AppServ\www\shihui\admin\searchshow.php on line 70

喜欢 (0)赏

[搞代码]

分享 (0)