我有一个带表的mysql DB,其中一个表中有一个日期类型字段,我想要最近通过的日期-所以我希望它按日期降序排列,但只从今天之前开始记录,然后使用LIMIT函数只取最前面的记录,此外还添加了WHERE子句,即优惠必须针对所选城市。
$result = mysql_query("
SELECT * FROM offers
WHERE city = ".$_SESSION["city"]."
ORDER BY exp_date DESC
LIMIT 0, 1");
向where子句添加另一个条件
$result = mysql_query("
SELECT * FROM offers
WHERE city = ".$_SESSION["city"]." and Date < CURRENT_DATE()
ORDER BY exp_date DESC
LIMIT 1");
SELECT * FROM deals WHERE city = 2 AND exp_date < CURDATE()
ORDER BY exp_date DESC LIMIT 0, 1
在Where中添加以下条件:
... and exp_date < CURDATE()
请参阅http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html.