如何组合两个独立的mysql查询 - How to combine two separate mysql queries

How to combine two separate mysql queries

组合这些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(我知道它已被弃用，但为了什么目的，我使用它更容易)，所以我不知道如何把这两个在一起。

将WHERE子句与AND子句合并。您也可以使用BETWEEN操作符，而不是同时测试>=和<=。

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

我找到了查询不工作的原因。

这只是因为查询的语法是错误的，因为我需要在变量周围的引号使其正常工作，像这样:

$reserved = mysql_query("Select * from reservations where '$timestamp' BETWEEN ReservationStart AND ReservationEnd AND '$ReservationEnd' BETWEEN ReservationStart AND ReservationEnd