<?php
$link = mysql_pconnect( "localhost","root","1234") or die(mysql_error());
mysql_select_db("",$link) or die(mysql_error());
mysql_query("SET NAMES UTF8");
?>< ?php
$sql="select * from order by 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>
</tr>
<?php
$i=0;
while($row=mysql_fetch_array($query)){
$i++;
?>
<tr>
<td><div align="center"><?php echo $i; ?></div></td>
<td><div align="left"><?php echo $row[""]; ?> </div></td>
<td><div align="left"><?php echo $row[""]; ?> </div></td>
</tr><?php }?>
< /table>
ไม่มีความคิดเห็น:
แสดงความคิดเห็น