大家幫忙看看。<?phprequire_once 'fun.php';//調用fun.php連接數據庫$StuNumber=$_GET['StuNumber'];//學號$StuName=$_GET['StuName'];//姓名$Project=$_GET['select'];//專業//生成sql語句的函數function getsql($StuNum,$StuNa,$Pro){$sql="select * from XSwhere";$note=0;if($StuNum){$sql.="學號 like '%$StuNum%'";$note=1;}if($StuNa){ if($note==1) {$sqlstr=" and "; }$sql.=$sqlstr."姓名 like'%$StuNa%'";$note=1;}if(strcmp("$Pro","所有專業")==1){ if($note==1) { $sqlstr=" and "; }$sql.=$sqlstr."專業名='$Pro'";$note=1;}if($note==0) { $sql="select * from XS"; }return $sql;}$pagesize=5;if(empty($_GET['page'])){$StuNum=$StuNumber;$StuNa=$StuName;$Pro=$Project;$sql=getsql($StuNum,$StuNa,$Pro);$res=mysql_query($sql);$rsc=mysql_fetch_array($res);//$num=mysql_num_rows($res); //查詢的總記錄數$pages=ceil($num/$pagesize);//頁數$page=1;}mysql_close();//關閉數據庫?>