想在分页上加首页和尾页
<?php<br /> extract($_REQUEST);<br /> $n=0; <br /> $query=mysql_query("select count(*) as sm from jiaoshi");<br /> mysql_query("set names 'GB2312'");<br /> $row=mysql_fetch_array($query);<br /> $count=$row['sm'];<br /> if(empty($offset))<br /> {$offset=0;}<br /> /*echo $offset;*/<br /> $where = (! isset($surplus)) ? '' : " where surplus='$surplus'";<br /> $query=mysql_query("select * from jiaoshi $where order by id asc limit $offset,$list_num") or die ("fail");<br /> mysql_query("set names 'GB2312'");<br /> <br /> while($row=mysql_fetch_array($query)){<br /> if(($n%2)!='0'){<br /> echo "<tr bgcolor=#CDE6C7>";}<br /> else{<br /> echo "<tr bgcolor=#FFFFFF>";<br /> }<br /> <br /> if($row['surplus']==0)<br /> $ss="不可选";<br /> else $ss="可选"; <br /> echo"<br /> <td height='22' class='STYLE1'> <div align='center'> ".$row['id']." </div></td><br /> <td height='22' class='STYLE1'> <div align='center'> ".$row['subject']." </div></td><br /> <td height='22' class='STYLE1'> <div align='center'> ".$row['teacher']." </div></td><br /> <td height='22' class='STYLE1'> <div align='center'> ".$row['zhicheng']." </div></td><br /> <td height='22' class='STYLE1'> <div align='center'> ".$row['number']." </div></td><br /> <td height='22' class='STYLE1'> <div align='center'> ".$row['xuehao']." </div></td><br /> <td height='22' class='STYLE1'> <div align='center'>".$ss."</div></td><br /> <td height='22' class='STYLE1'> <div align='center'> <a href=xiangxiziliao.php?id=".$row['id'].">查看</a></div></td><br /> </tr> ";<br /> $n++;<br /> }<br /> <br /> ?>
