php - SQL按日期和时间排序不起作用

Question

我正在尝试按时间和日期对消息进行排序，但它不起作用:这是我的代码:

$sql="SELECT id, message, sender, recipient, date, time, IF(recipient = ".$_SESSION["user"]["id"].", 'received', 'sent') AS direction
        FROM message
        WHERE
            (recipient = $friend_id OR sender = $friend_id)
            AND id > $last_message_id ORDER BY time AND date ASC";

Answer 1

您需要像这样将 ASC 放入两列:-

$sql="SELECT id, message, sender, recipient, date, time, IF(recipient = ".$_SESSION["user"]["id"].", 'received', 'sent') AS direction
        FROM message
        WHERE
            (recipient = $friend_id OR sender = $friend_id)
            AND id > $last_message_id ORDER BY time ASC, date ASC";