我尝试了许多解决方案,没有解决方案。如果我评论DESC查询,则页面加载正常,但没有注释,如果将查询放回中,我会收到错误。我看不到我在做错什么,直到我解决这个问题。任何帮助将不胜感激。
<!-- Posted Comments -->
<?php //post comments query
$query = "SELECT * FROM comments WHERE comment_post_id = {$the_post_id} ";
$query .= "AND comment_status = 'Approved' ORDER BY comment_id = DESC ";
//$query .= "ORDER BY comment_id = DESC ";
$select_comment_query = mysqli_query($connection, $query);
if(!$select_comment_query) {
die('Query Failed' . mysqli_error($connection));
}
while ($row = mysqli_fetch_assoc($select_comment_query)) {
$comment_date = $row['comment_date'];
$comment_content = $row['comment_content'];
$comment_author = $row['comment_author'];
?>
<!-- Comment -->
<div class="media">
<a class="pull-left" href="#">
<img class="media-object" src="http://placehold.it/64x64" alt="">
</a>
<div class="media-body">
<h4 class="media-heading"><?php echo $comment_author; ?>
<small><?php echo $comment_date; ?></small>
</h4>
<?php echo $comment_content; ?>
</div>
</div>
<?php } ?>
</div>
我相信=
是不必要的。也许您打算:
ORDER BY comment_id DESC
这命令comment_id
降序设置的结果。
或,如果您希望特定的comment_id
首先出现:
ORDER BY comment_id = ? DESC
其中 ?
是您首先想要的值。
订购列表列名,带有默认值ASC。
如果您想按降序排序数据,则列名称放置空间并添加ASC或DESC用于按升序排序
Order by column_name ASC
Or
Order by column_name
用于以降序排序
Order by column_name DESC