PHP 按日期排序似乎不起作用 - php ORDER BY date doesn't seem to work

php ORDER BY date doesn't seem to work

本文关键字：不起作用排序日期 PHP | 更新日期: 2023-09-27

我只想显示折扣为当前状态的书籍。交易开始和交易结束表示窗口。但是我搞砸了一些东西。

$sqlCommand = "SELECT id,bookcover FROM booklist WHERE category1='$bookid' OR category2='$bookid' OR category3='$bookid' AND dealstart >= CURDATE() AND dealend is >= CURDATE()";

您的 SQL 语句中似乎存在语法错误，请删除"is"：

lCommand = "SELECT id,bookcover FROM booklist WHERE category1='$bookid' OR category2='$bookid' OR category3='$bookid' AND dealstart >= CURDATE() AND dealend >= CURDATE()";

如果查询仍然不起作用，请回显"lCommand"并查看它正在产生什么，然后尝试针对您的数据库运行该查询。

像这样？

$sqlCommand = "SELECT
                   id,
                   bookcover
               FROM
                   booklist
               WHERE
                   category1='$bookid' OR
                   category2='$bookid' OR
                   category3='$bookid' AND
                   dealstart >= CURDATE() AND
                   dealend >= CURDATE()
               ORDER BY
                   dealend DESC";