php分页输出问题
<form method="post" name="form" id="form" ction="index.php?act=query" onSubmit="return chkinput_search(this)">
<input id="search" type="text" name="search" size="60" value="" placeholder="请输入搜索"/><select name="xuanze"id="xuanze" >
<option selected value="shoptype">类型</option>
<option value="user">账号</option>
<option value="shopname">店名</option>
</select>
<input class="submit"name="submit" type="submit" value="查询" />
</form>这里是 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);//在这里也出错
?><table class="jieguo"width="100%" border="1" cellspacing="1" cellpadding="2">
<tr style=" background:url(images/nav_03.jpg)">
<td height="25px;" width="100">帐号</td>
<td width="100">联系人</td>
<td width="200">店铺名称</td>
<td width="60">类型</td>
<td width="120">联系电话</td>
<td width="240">联系地址</td>
</tr>
<?php
if($info){
do{ ?>
<tr>
&l