php - 如何仅在超过特定日期时才启用 mysql 条件

Question

在这里，我需要检查我的数据库，如果达到当前日期，那么我必须执行编码，否则必须跳过

function list_hotel_default($country,$city,$location,$fromdate,$todate,$roomtype,$adults,$child_no)
{   
  $condition="country='$country' AND city='$city' AND location='$location'  AND     show2web='1' AND expiry_date is greater than current date";                              
  $active_hotel_get_qry =   mysql_query("SELECT * FROM  hoteldetails WHERE ".$condition);
}

如果有其他情况，则不应执行

如何做到这一点？

Answer 1

如果你只想用日期值检查它，那么你可以使用

function list_hotel_default($country,$city,$location,$fromdate,$todate,$roomtype,$adults,$child_no)
{

  $condition="country='$country' AND city='$city' AND location='$location'  AND     show2web='1' AND expiry_date > CURDATE()"; 

  $active_hotel_get_qry =   mysql_query("SELECT * FROM  hoteldetails WHERE ".$condition);
}