《mysql_fetch_object》 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>

<body>

<?php
$link=mysql_connect("localhost","root","haifeng");
$db_selected=mysql_select_db("haifeng",$link);
mysql_query("set names gb2312");
$sql=mysql_query("select * from testhaifeng");
$info=mysql_fetch_object($sql);

?>

<table width="200" border="0">
  <tr>
    <td>序号</td>
    <td>用户名</td>
    <td>密码</td>
    <td>等级</td>
  </tr>
  <?php
do{

?>
  
  <tr>
    <td> <?php echo $info->Id;?></td>
    <td> <?php echo $info->username; ?></td>
    <td> <?php echo $info->passworda; ?></td>
    <td> <?php echo $info->type; ?></td>
  </tr>
  <?php
  }while($info=mysql_fetch_object($sql));
  ?>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
</table>

</body>
</html>
<?php
mysql_free_result($sql);
mysql_close($link);
?>