for ($i=1; $i <= $pages; $i++) {
$temps = "<a href='".$PHP_SELF.'?offset='.$i."'>".$i."</a>";
print $temps;
print " ";
}
//Check whether it is the last page
if ($pages!=0 && $offset!=$pages) {
$newoffset=$offset+1;
print "<a href='$PHP_SELF?offset=$newoffset'>Next Page</a>";
} else print "Next page";
print '</div> </td>';
print '<td width="50%"> <div align="center">';
print "Current page:".$offset." Total".$pages."Pages";
print '</div> </td>';
print "</table>";
//Processing details
print '<table width="100%" border="1">';
print '<tr class="text"> ';
print '<td width="6%"> <div align="center">New</div> </td>';
print '<td width="5%"> <div align="center">Click</div> </td>';
print '<td width="53%"> <div align="center">theme</div> </td>';
print '<td width="10%"> <div align="center">creator</div> </td>';
print '<td width="5%"> <div align="center">Reply</div> </td>';
print '<td width="11%"> <div align="center">Last modification time </div> </td>';
print '<td width="10%"> <div align="center">Reply</div> </td>';
print '</tr>';
$query = 'select id,state,readcount,title,createman,replycount,replytime,replyman
from fr_t_forumtitle order by replytime desc LIMIT '.$curline.',20';
$res = mysql_query($query, $dbh);
// $li_rownum = mysql_num_rows($res);
// for ($i=1; $i<=$li_rownum; $i++) {
// $row = mysql_fetch_row($res);
while ($row = mysql_fetch_array($res)) {
print '<tr class="text"> ';
print '<td width="6%"> '.$row["state"].'</td>';
print '<td width="5%"><div align="center">'.$row["readcount"].'</td>';
$tempstr = "<a href='?readflag=".$row["id"]."'>".$row['title']."</a>";
print '<td width="53%"> '.$tempstr.'</td>';
// print '<td width="48%">'.$row["title"].'</td>';
print '<td width="9%"> '.$row["createman"].'</td>';
print '<td width="5%"><div align="center">'.$row["replycount"].'</td>';
$temptime = substr($row["replytime"],5,11);
print '<td width="11%"> '.$temptime.'</td>';
print '<td width="10%"> '.$row["replyman"].'</td>';
print '</tr>';
}
print "</table>";
//Print the end of the table
print '<table width="100%" border="0">';
print '<tr class="text"> <td width="50%"> <div align="center">';
if ($offset <> 1) { //If the offset is 0, the link from the previous page will not be displayed
$newoffset=$offset - 1;
print "<a href='$PHP_SELF?offset=$newoffset'>Previous page</a>";
} else {
print "Previous page";
print " ";
}
//Calculate the total number of pages required
for ($i=1; $i <= $pages; $i++) {
$temps = "<a href='".$PHP_SELF.'?offset='.$i."'>".$i."</a>";
print $temps;
print " ";
}
//Check whether it is the last page
if ($pages!=0 && $offset!=$pages) {
$newoffset=$offset+1;
print "<a href='$PHP_SELF?offset=$newoffset'>Next Page</a>";
} else print "Next page";
print '</div> </td>';
print '<td width="50%"> <div align="center">';
print "Current page:".$offset." Total".$pages."Pages";
print '</div> </td>';
print "</table>";
//end of Print the end of the table
?>
<?
include ("c:");
?>
</body>
</html>