我想输出最新四条,用while循环输出,但是实际输出了N条,而且数据库只有一条,它就循环输出了N次,网页差点就打不开,应该怎么逐条输出查询出来的内容,有几条输出几条<?php
$str="select name,time,title,comment from comment order by time desc limit 0,4";
$result=mysql_query($str);
$row = mysql_fetch_array($result);
if(!$row){
?>
<p>There is no comment!</p>
<?php
}
else{
while($row){
echo $row['name']."于".$row['time']."发表:<br/>";
echo $row['title']."<br/>";
echo $row['comment']."<br/>";
}
}
?>
$str="select name,time,title,comment from comment order by time desc limit 0,4";
$result=mysql_query($str);
$row = mysql_fetch_array($result);
if(!$row){
?>
<p>There is no comment!</p>
<?php
}
else{
while($row){
echo $row['name']."于".$row['time']."发表:<br/>";
echo $row['title']."<br/>";
echo $row['comment']."<br/>";
}
}
?>
解决方案 »
- 关于mysql 5.5.30的安装问题
- mysql文件导入问题
- mysql 操作技巧
- 5.0.77升级到5.1.47的操作步骤
- 请教定时转存问题
- 请教sql语句,如何用like关联两个表中的字段
- 数值型和字符型做主键的效率问题,会相差多少
- 我问一下myqsl 日期data字体,设置默认型的,自动提取系统日期,应该如何设置字段属性啊
- Invalid authorization specification: Access denied for user: '[email protected]' (Using password: YES)
- 存储过程的备份和恢复问题
- 请问多表统计怎么弄啊?
- mysql语句优化和添加条件~
<?php
$str="select name,time,title,comment from comment order by time desc limit 0,4";
$result=mysql_query($str);
$row = mysql_fetch_array($result);
if(!$row){
?>
<p>There is no comment!</p>
<?php
}
else{
while($row){
echo $row['name']."于".$row['time']."发表:<br/>";
echo $row['title']."<br/>";
echo $row['comment']."<br/>";
$row = mysql_fetch_array($result);
}
}
?>
$str="select name,time,title,comment from comment order by time desc limit 0,4";
$result=mysql_query($str);
$row = mysql_fetch_array($result);
if(!$row){
?>
<p>There is no comment!</p>
<?php
}
else{
while($row = mysql_fetch_array($result)){ // changed by ACMAIN
echo $row['name']."于".$row['time']."发表:<br/>";
echo $row['title']."<br/>";
echo $row['comment']."<br/>";
}
}
?>