查询失败您的SQL语法有错误;检查与您的MariaDB服务器版本相对应的手册以获取正确的语法,以在第1行的'comment_status ='Approved'ORDER BY comment_id DESC'附近使用
这是我的代码
<?php
$query = "SELECT * FROM comments WHERE comment_post_id = {$the_post_id}";
$query .= "AND comment_status = 'Approved' ";
$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_array($select_comment_query)) {
$comment_date = $row['comment_date'];
$comment_content = $row['comment_content'];
$comment_author = $row['comment_author'];
?>
<!-- Comments -->
<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 } ?>
如果我禁用以下代码,则可以正常工作
$query .= "AND comment_status = 'Approved' ";
$query .= "ORDER BY comment_id DESC";
谢谢
尝试包含一个空格:
$query .= " AND comment_status = 'Approved' ";
注意:如果要调试这些类型的问题,请在运行查询字符串之前输出查询字符串。通常问题很明显。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句