首先,您要进行
SELECt两次相同的操作。这是不必要的,因为您可以计算行数并从单个查询中获取数据。除此之外,
commentid用注释表的唯一ID替换您,即可设置好。替换
DESC为
ASC以颠倒排序顺序。
<?php $grab = mysql_query("SELECT * FROM comment WHERe articleid='" . mysql_real_escape_string($_GET['id']) . "' ORDER BY commentid DESC"); $comments = mysql_num_rows($grab); if (mysql_num_rows($grab)==0) { echo "<div >Sorry, it looks like their are no comments to be displayed, check back later!</div>"; } while($row = mysql_fetch_array($grab)){?>


