我只是想在帖子上选择最新的3条评论,并按照ASC顺序订购.
这将选择最后3行,但我需要它们以相反的顺序：
MysqL_query(" SELECT * FROM comments WHERE postID='$id' AND state='0' ORDER BY id DESC LIMIT 3")
您可以稍后对其进行反向排序.
原文链接：https://www.f2er.com/php/133480.htmlSELECT *
FROM (SELECT * FROM comments
WHERE postID='$id'
AND state='0'
ORDER BY id DESC
LIMIT 3) t
ORDER BY id ASC;
