php - MySQL 按较大 ID 排序

Question

如何从最大到最低下订单？

我正在使用:

mysqli_query($con, "SELECT * FROM builds 
                    WHERE approved = 'yes' AND ORDER BY build_id LIMIT 0, 10");

但我收到此错误:

 Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\wamp\www\pcbuilds\index.php on line 9

有什么办法让它发挥作用吗？

Answer 1

您的查询看起来错误，您只有 AND。删除该 AND

  SELECT * FROM builds 
                WHERE approved = 'yes'  ORDER BY build_id DESC LIMIT 0, 10