php - php 中的 mysql 查询有问题吗？

Question

$sql = "SELECT s1.roomtype, s1.roomno, s1.checkin,s1.checkout FROM
guestrocordtransac s1
JOIN guestrocord s2
ON s1.roomtype = s2.roomtype  AND s1.roomno != s2.roomno 
WHERE s1.checkin = '".$date1."' BETWEEN  s2.checkin  = '".$date1."' AND s2.checkout='".$date2."' "; 

我不知道哪里出了问题..我必须检查房型、房间号、入住日期和退房日期之间的情况...

我从表单中获取房间类型、房间号、 checkin 、 checkout 值。现在我必须将其与数据库进行比较。

Answer 1

这里

$sql = "SELECT s1.roomtype, s1.roomno, s1.checkin,s1.checkout FROM
guestrocordtransac s1
JOIN guestrocord s2
ON s1.roomtype = s2.roomtype  AND s1.roomno != s2.roomno 
WHERE s1.checkin = '".$date1."' BETWEEN  s2.checkin  = '".$date1."' AND s2.checkout='".$date2."' ";

您的 where 子句中的语法无效，因为您不应检查 Between 操作数中的相等性。这应该可以解决问题:

$sql = "SELECT s1.roomtype, s1.roomno, s1.checkin,s1.checkout FROM
guestrocordtransac s1
JOIN guestrocord s2
ON s1.roomtype = s2.roomtype  AND s1.roomno != s2.roomno 
WHERE s1.checkin = '".$date1."' BETWEEN  '".$date1."' AND '".$date2."' ";

了解更多关于之间<​​ here .