php - 我如何在mysql中使用order和between

Question

我在这个 mysql 代码中使用 Order 和 Between 时遇到问题:

<?php 

$connection = mysqli_connect("localhost","my_user","my_password","my_db");
$id = $_GET["id"];
$query = "Select * from my_data where id between ($id+1) and ($id+4)";
$result = mysqli_query($connection,$query);
while ($row = mysqli_fetch_assoc($result)) {

    $array[] = $row;    
}
header('Content-Type:Application/json');
echo json_encode($array);?>

我想按id降序输出请帮助我

Answer 1

所以您希望 ID 最高的条目优先？那么它应该是这样的:

Select * from my_data where id between ($id+1) and ($id+4) ORDER BY id DESC