<?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>");

}

?>