<? $pagesize=10; if($action=="show") { switch($sort) { case "1":$sortby="id";break; case "2":$sortby="click";break; case "3";$sortby="title";break; default:$sortby="id"; } if($isdesc=="1") $temp_isdesc=""; else $temp_isdesc="desc"; if($type==""||$type==0) $temp=""; else $temp="where type=".$type; $rs=mysql_fetch_array(mysql_query("select count(*) from download ".$temp,$cn)); $max_page=$rs[0]; if($page>=$max_page) $page=$max_page-$pagesize; if($page<=0) $page=0; $result=mysql_query("select * from download ".$temp." order by ".$sortby." ".$temp_isdesc." limit ".$page.",".$pagesize,$cn); } if($action=="search") {
switch($select) { case "软件名称":$object="title";break; case "作者":$object="author";break; case "简介":$object="say"; } if($isdesc=="1") $temp_isdesc=""; else $temp_isdesc="desc"; switch($sort) { case "1":$sortby="id";break; case "2":$sortby="click";break; case "3";$sortby="title";break; default:$sortby="id"; } if($type==""||$type==0) $temp=""; else $temp="and type=".$type;
$rs=mysql_fetch_array(mysql_query("select count(*) from download where ".$object." like('%".$content."%') ".$temp,$cn)); $max_page=$rs[0]; if($page>=$max_page) $page=$max_page-$pagesize; if($page<=0) $page=0; $sql="select * from download where ".$object." like('%".$content."%') ".$temp." order by ".$sortby." ".$temp_isdesc." limit ".$page.",".$pagesize; $result=mysql_query($sql,$cn); } ?>
