日期:2014-05-17  浏览次数:20509 次

请高人加分页功能
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
  <td valign="top" bgcolor="#FFFFFF"><table width="99%" height="510" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="tableBorder_gray">
  <tr>
  <td height="510" align="center" valign="top" style="padding:5px;"><table width="98%" height="487" border="0" cellpadding="0" cellspacing="0">
  <tr>
  <td align="center" valign="top">
<table width="723" height="37" border="0" cellpadding="0" cellspacing="0">
  <tr>
  <td background="Images/dangan.gif">&nbsp;</td>
  </tr>
  </table>
<form name="form1" method="post" action="">
<table width="98%" height="38" border="1" cellpadding="1" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#9ECFEE" class="tableBorder_gray">
  <tr>
  <td align="center">
&nbsp;<img src="Images/search.gif" width="37" height="29"></td>
  <td>&nbsp;&nbsp;请选择查询依据:
  <select name="f" class="wenbenkuang" id="f">
  <option value="<?php echo "b.barcode";?>">条形码</option>
  <option value="<?php echo "t.typename";?>">类别</option>
  <option value="<?php echo "b.bookname";?>" selected>书名</option>
  <option value="<?php echo "b.author";?>">作者</option>
  <option value="<?php echo "p.pubname";?>">出版社</option>
  <option value="<?php echo "c.name";?>">书架</option>
  </select>
  <input name="key1" type="text" id="key1" size="50">
  <input name="Submit" type="submit" class="btn_grey" value="查询"></td>
  </tr>
</table>
</form>
<?php 
include("conn/conn.php");
$query=mysql_query("select b.*,c.name as bookcasename,p.pubname,t.typename from tb_bookinfo b left join tb_bookcase c on b.bookcase=c.id join tb_publishing p on b.ISBN=p.ISBN join tb_booktype t on b.typeid=t.id");
$result=mysql_fetch_array($query);
if($result==false){
?>
  <table width="100%" height="30" border="0" cellpadding="0" cellspacing="0">
  <tr>
  <td height="36" align="center">暂无图书信息!</td>
  </tr>
  </table>
<?php
 }
 else{
 ?>  
  <table width="98%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#D2E3E6" bordercolorlight="#FFFFFF">
  <tr align="center" bgcolor="#D0E9F8"><