<?php
if(!$whichpage)
{  
$notepage=1;
}
else
{
$notepage=$whichpage;
}
$noterecs=0;
$pagesize=10;
$bbsconn=mysql_connect(localhost,root);
mysql_select_db(rainwindy,$bbsconn);
$bbsresult=mysql_query(select * from bbs order by id desc,$bbsconn);
$rsnum=mysql_num_rows($bbsresult);
$pagecount=ceil($rsnum/$pagesize);
mysql_data_seek($bbsresult,($notepage-1)*10);
?>
<div align=right>

<table border=0 width=730 cellspacing=0 cellpadding=0>
    <tr>
      <td width=41 height=30 bgcolor=#C0C0C0 bordercolor=#0000FF valign=middle align=center>编号</td>
      <td width=100 height=30 bordercolor=#0000FF bgcolor=#C0C0C0 valign=middle align=center>用户名</td>
      <td width=100 height=30 bordercolor=#0000FF bgcolor=#C0C0C0 valign=middle align=center>发表人</td>
      <td width=311 height=30 bordercolor=#0000FF bgcolor=#C0C0C0 valign=middle align=center>文章标题</td>
      <td width=239 height=30 bordercolor=#0000FF bgcolor=#C0C0C0 valign=middle align=center>发表时间</td>
   </tr>
<?php
while(($bbsrow=mysql_fetch_array($bbsresult)) && ($noterecs<=9))
{

?>
<tr>
      <td width=41 height=30 bgcolor=#FFFFCC valign=middle align=center><?php echo $bbsrow[id] ?></td>
      <td width=100 height=30 bgcolor=#FFFFCC valign=middle align=center><?php echo $bbsrow[usr] ?></td>
      <td width=100 height=30 bgcolor=#FFFFCC valign=middle align=center><?php echo $bbsrow[name] ?></td>
      <td width=311 height=30 bgcolor=#FFFFCC valign=middle align=center><a href=bbsdisp.php?whichnote=<?php echo $bbsrow[id] ?> target=disp><?php echo $bbsrow[title] ?></a></td>
      <td width=239 height=30 bgcolor=#FFFFCC valign=middle align=center><?php echo $bbsrow[bbstime] ?></td>
       
</tr>
<?php
$noterecs=$noterecs+1;
}
?>
</table>

</div>
<br>
<br>
<center>
<?php
$pad=0;
for($counter=1;$counter<=$pagecount;$counter++)
{
if($counter>=10)
{  
$pad=;
}

echo(<font size=+1 color=red><a href=bbsbl.php?whichpage=$counter>.$pad.$counter.</a></font>&nbsp;&nbsp;);
}
?>