php - MySql 查询省略了最后记录的行

Question

我的 MYSQL 查询工作正常，除了一件事......它省略了我表中最后记录的行。看看我的代码；

$Articlesql3 = "SELECT * FROM Group WHERE Group_ID = '$id' ORDER BY ID DESC";
$Articlequery3 = mysqli_query($connection, $Articlesql3);
$Articlerow3 = mysqli_fetch_object($Articlequery3);

while($Articlerow3 = mysqli_fetch_object($Articlequery3)){
      $Articleid3 = $Articlerow3->Article_ID;
      $Articlesql4 = "SELECT * FROM Articles WHERE Article_ID = '$Articleid3'";
$Articlequery4 = mysqli_query($connection, $Articlesql4);
while($Articlerow4 = mysqli_fetch_object($Articlequery4)){
 echo "<p><a href='ArticleReader.php?ID=$Articlerow4->Article_ID&id=$id'></i> $Articlerow4->Article_Name</a></p>";}}

Answer 1

只需删除这一行:

$Articlerow3 = mysqli_fetch_object($Articlequery3);

您正在获取结果。然后在 while 中再次获取结果。

由于 order by id desc 而缺少最后一个。