分组和不工作排序 - group by and order by not working

group by and order by not working

本文关键字：工作排序 | 更新日期: 2023-09-27

我正试着让团队和秩序一起工作，但是没有人能告诉我我做错了什么。

$get1_msg1 = mysqli_query($con, "select * from (select message_id, sender, receiver, message, read_status, time_sent from user_messages where receiver='".$_SESSION['userid']."' order by time_sent desc ) as temp group by sender order by time_sent desc ");

我不知道我做错了什么

根据您的评论，您可以尝试

    "select message_id, sender, receiver, message, read_status, time_sent 
    from user_messages  where message_id  in (
          select message_id 
          from user_messages  
          where (sender, time_sent) in ( 
                  select  sender, max(time_sent )
                  from user_messages 
                  where receiver='".$_SESSION['userid']."' 
                  group by sender
          )
    )
    and receiver='".$_SESSION['userid']."'";