php显示表格,php – 显示所有表格行

我制作了一个html表,我可以从

mysql表中检索数据.但是,我只能显示最后一个注册表.我想向他们展示一切.

我的代码：

$con = mysql_connect("localhost","x","x");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db("x", $con);

$query = "SELECT * FROM noticias";

$comments = mysql_query($query);

while($row = mysql_fetch_array($comments, MYSQL_ASSOC))

{

$name = $row['nome'];

$email = $row['email'];

$website = $row['lugar'];

$comment = $row['comment'];

$timestamp = $row['data'];

$name = htmlspecialchars($row['nome'],ENT_QUOTES);

$email = htmlspecialchars($row['email'],ENT_QUOTES);

$website = htmlspecialchars($row['lugar'],ENT_QUOTES);

$comment = htmlspecialchars($row['comment'],ENT_QUOTES);

}

mysql_close($con); ?>

NomeE-mailLugarNotíciaData

<?php echo $name ?>$email$website$comment$timestamp

如你所见,现在我只尝试一行.到目前为止,我正在显示最后一个注册表.我想向他们展示所有,我该怎么做？