第一個查詢有效并顯示正確的結果。當我添加額外的 AND 條件時，我收到“試圖獲取非對象的屬性”錯誤。我可以在一個 OR 和另一個條件下成功執行。這是回顯的查詢：SELECT * FROM scores WHERE (sortDate <= 20190629 AND sport = football) AND (homeID = 4 OR awayID = 4) ORDER BY gameDate DESC我確定變量正在通過。這個工作正常：$sql = "SELECT * FROM scores WHERE sortDate <= $todayAND (homeID = $teamID OR awayID = $teamID)ORDER BY gameDate DESC";這個給出了一個錯誤（添加了 AND）：$sql = "SELECT * FROM scores WHERE (sortDate <= $today AND sport = $sportID)AND (homeID = $teamID OR awayID = $teamID)ORDER BY gameDate DESC";
1 回答
狐的傳說
TA貢獻1804條經驗 獲得超3個贊
嘗試這個
$sql = "SELECT * FROM scores
WHERE (sortDate <= $today AND sport = '$sportID')
AND (homeID = $teamID OR awayID = $teamID)
ORDER BY gameDate DESC";
或者
$sql = "SELECT * FROM scores
WHERE (sortDate <= $today) AND (sport = $sportID)
AND (homeID = $teamID OR awayID = $teamID)
ORDER BY gameDate DESC";
- 1 回答
- 0 關注
- 213 瀏覽
添加回答
舉報
0/150
提交
取消