一个程序下载的管理程序(二)

//主程序download.php源代码如下:
<?session_start();?>

<?
$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);
}
?>

对不起，没能找到你想要的记录

?>
<?if($action!="publish"){?>

=1){?> &type;=&select;=&sort;=&isdesc;=>第一页 =1){?> &action;=search&content;=&type;=&select;=&sort;=&isdesc;=>上一页 &action;=search&content;=&type;=&select;=&sort;=&isdesc;=>下一页 &action;=search&content;=&type;=&select;=&sort;=&isdesc;=>最后页 =1){?> &action;=show&sort;=&isdesc;=>第一页 =1){?> &type;=&action;=show&sort;=&isdesc;=>上一页 &type;=&action;=show&sort;=&isdesc;=>下一页 &type;=&action;=show&sort;=&isdesc;=>最后页

    </font></div>   
</td>   
<td width="539" height="25">    
  <div align="left"><font size="2">    
    <?=$rs["say"];?>   
    <br>   
    <a href="sign.php?action=mail&id;=<?=$rs["id"]?>&title;=<?=$rs["title"]?>&type;=<?=$rs["type"]?>">如果该链接有问题,请点这里    
    </a></font></div>   
</td>   
<td width="31" height="25">    
  <div align="center"><font size="2">   
    <?=$rs["size"];?>   
    </font></div>   
</td>   
<td width="31" height="25">    
  <div align="center"><font size="2">   
    <?=$rs["click"];?>   
    </font> </div>   
</td>   
<td width="82" height="25">    
  <div align="center"><font size="2">   
    <?=$rs["ttime"];?>   
    </font> </div>   
</td>   

<?}?>
<?if($action=="publish"){?>