php - 如何组合两个单独的 mysql 查询

Question

组合这些 mysql 查询的正确语法是什么？

$reserved = mysql_query("Select * from reservations where $timestamp >= ReservationStart AND $timestamp <= ReservationEnd");

和

$reserved2 = mysql_query("Select * from reservations where $ReservationEnd >= ReservationStart AND $ReservationEnd <= ReservationEnd");

我希望预订同时满足这两个条件，但我对使用 mysql 还很陌生(我知道它已被弃用，但出于我使用它的目的，它更容易)，所以我不确定如何将这两者放在一起。

Answer 1

合并WHERE带有 AND 的子句.您还可以使用 BETWEEN运算符(operator)而不是同时测试 >=和 <= .

$reserved = mysql_query("Select * 
    from reservations 
    where $timestamp BETWEEN ReservationStart AND ReservationEnd
    AND $ReservationEnd BETWEEN ReservationStart AND ReservationEnd") or die(mysql_error());