<?php
$link = mysql_pconnect( "localhost","root","root") or die(mysql_error());
mysql_select_db("28403db",$link) or die(mysql_error());
mysql_query("SET NAMES UTF8");
?>
<?php
$sql="select * from book order by idbook asc";
$query=mysql_query($sql) or die(mysql_error());
$num=mysql_num_rows($query);
echo "จำนวนทั้งหมด ".$num." เล่ม<br>";
?>
<table width="554" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="51"><div align="center">ลำดับ</div></td>
<td width="89"><div align="center">รหัสหนังสือ</div></td>
<td width="170"><div align="center">ชื่อหนังสือ</div></td>
<td width="170"><div align="center">ชื่อสำนักพิมพ์</div></td>
<td width="170"><div align="center">วันที่ผลิต</div></td>
<td width="170"><div align="center">จำนวนเล่ม</div></td>
</tr>
<?php
$i=0;
while($row=mysql_fetch_array($query)){
$i++;
?>
<tr>
<td><div align="center"><?php echo $i; ?></div></td>
<td><div align="center"><?php echo $row["idbook"]; ?> </div></td>
<td><div align="center"><?php echo $row["namebook"]; ?> </div></td>
<td><div align="center"><?php echo $row["company"]; ?> </div></td>
<td><div align="center"><?php echo $row["datebook"]; ?> </div></td>
<td><div align="center"><?php echo $row["numbook"]; ?> </div></td>
</tr><?php }?>
</table>
