想在分页上加首页和尾页
<?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 />
?>
