<? print"<tr valign=top><TH align=center>书名</TH><TH align=center>作者</TH><TH
align=center>出版社</TH><TH align=center>页数</TH><TH align=center>价格</TH><TH
align=center>action</TH></TR>\n";
if(isset($which)&&isset($from)&&isset($total)){
$db=@mysql_connect("SIMBA","simba","19811116");
if($db==false){
print"connect failed!";
exit();
}
$to=($total<($from+$MAXROWS))?($total-$from):$MAXROWS;
$query="select isdn,bookname,author,bookconcern,realprice from books wher
e class=$which order by publishdate limit $from+0,$to;";
$res=@mysql_db_query("bookseller",$query,$db);
if($res==false){
print"Query failed!";
exit();
}
if($total!=0){
print"显示记录".($from+0)."-";
print $to+$from-1;
print"(总共 $total)\n<TR>"; for($i=0;$i<mysql_num_rows($res);$i++){
$row=mysql_fetch_row($res);
for($j=2;$j<7;$j++){
print"<TD align=center>$row[$j]</TD>"; }
print"<TD align=center>";
}
print"<tr><td colspan=7 align=center>";
print"<A href=\"$PHP_SELF?from=0&total=$total\">";
print"首页</A> ";
if($from>=2*$MAXROWS){
print"<A href=\"$PHP_SELF?from=";
print($from-$to)."&total=$total\">上一页</A> ";
}
if(($from+$to)<$total){
print"<A href=\"$PHP_SELF?from=";
print($from+$to)."&total=$total\">下一页</A> ";
}
if(($total>$MAXROWS)){
print"<A href=\"$PHP_SELF?from=";
print($total-$total%$MAXROWS);
print"&total=$total\">末页</A>";
}
print"</td></tr>\n";
}?>
</tbody>
</table> </td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</body>
</html>
align=center>出版社</TH><TH align=center>页数</TH><TH align=center>价格</TH><TH
align=center>action</TH></TR>\n";
if(isset($which)&&isset($from)&&isset($total)){
$db=@mysql_connect("SIMBA","simba","19811116");
if($db==false){
print"connect failed!";
exit();
}
$to=($total<($from+$MAXROWS))?($total-$from):$MAXROWS;
$query="select isdn,bookname,author,bookconcern,realprice from books wher
e class=$which order by publishdate limit $from+0,$to;";
$res=@mysql_db_query("bookseller",$query,$db);
if($res==false){
print"Query failed!";
exit();
}
if($total!=0){
print"显示记录".($from+0)."-";
print $to+$from-1;
print"(总共 $total)\n<TR>"; for($i=0;$i<mysql_num_rows($res);$i++){
$row=mysql_fetch_row($res);
for($j=2;$j<7;$j++){
print"<TD align=center>$row[$j]</TD>"; }
print"<TD align=center>";
}
print"<tr><td colspan=7 align=center>";
print"<A href=\"$PHP_SELF?from=0&total=$total\">";
print"首页</A> ";
if($from>=2*$MAXROWS){
print"<A href=\"$PHP_SELF?from=";
print($from-$to)."&total=$total\">上一页</A> ";
}
if(($from+$to)<$total){
print"<A href=\"$PHP_SELF?from=";
print($from+$to)."&total=$total\">下一页</A> ";
}
if(($total>$MAXROWS)){
print"<A href=\"$PHP_SELF?from=";
print($total-$total%$MAXROWS);
print"&total=$total\">末页</A>";
}
print"</td></tr>\n";
}?>
</tbody>
</table> </td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</body>
</html>
http://www.pconline.com.cn/pcedu/empolder/wz/php/10209/88055.html