<?php

$wherelist=array();

if(!empty($_GET['sid']))

{

$wherelist[]=" sid like '%".$_GET['sid']."%'";?

}

if(!empty($_GET['sname']))

{

$wherelist[]=" sname like '%".$_GET['sname']."%'";

}if(!empty($_GET['ssex']))

{

$wherelist[]=" ssex like '%".$_GET['ssex']."%'";

}

$where="";

if(count($wherelist)>0)

{

$where=" where ".implode(' and ',$wherelist);//implode 把數組元素組合為字符串

}

//分頁的實現原理

//1.獲取數據表中總記錄數

$sql="select * from student? $where ";?

$result=mysql_query($sql);

$totalnum=mysql_num_rows($result);

//每頁顯示條數

$pagesize=8;

//總共有幾頁

$maxpage=ceil($totalnum/$pagesize);

$page=isset($_GET['page'])?$_GET['page']:1;//isset函數是檢測變量是否設置。

if($page <1)

{

$page=1;

}

if($page>$maxpage)

{

$page=$maxpage;

}

$limit=" limit ".($page-1)*$pagesize.",$pagesize";//顯示當前頁

$sql0="select yhouse from yuangong where yid='{$_COOKIE['a']}'";

$rs0=mysql_query($sql0,$link);

$row0=mysql_fetch_assoc($rs0);

$yh=$row0['yhouse'];

$sql1="select * from student $where order by sid desc $limit"; //此處加了id降序

$res=mysql_query($sql1);

?>

為甚么我$sql1="select * from student where $yh=shourse $where order by sid desc $limit"; 變成這樣搜索功能就不行了呢？求幫忙謝謝你們！