這是我的 SQL - 使用 ReadBeanPHP 查詢(xún)。$idItem = $this->route['alias']; //some $_GET value$product = \R::findMulti('listings, users', 'SELECT listings.*, users.* RIGHT JOIN listings.id_user = users.id_user WHERE listings.id = ? AND listings.status = 0', [$idItem]);這是一個(gè)錯(cuò)誤,它把我打印出來(lái) Code error ExceptionText error SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'JOIN listings.id_user = users.id_user WHERE listings.id = 4 AND lis' at line 2Where error /opt/lampp/htdocs/sellbuyschool42/vendor/gabordemooij/redbean/RedBeanPHP/Driver/RPDO.phpLine error 194我按照 ReadBeanPHP 官方網(wǎng)站上的說(shuō)明做了所有事情https://redbeanphp.com/index.php?p=/finding 我想獲得幾個(gè)所謂的 bean,但出現(xiàn)錯(cuò)誤?;蛘?,如果有人知道將兩個(gè)表與 ReadBeanPHP 結(jié)合起來(lái)有多容易,那將是可行的。還提供桌子的照片。
ReadBeanPHP SQL 查詢(xún)沒(méi)有通過(guò)。有人看到錯(cuò)誤了嗎?一切都是手動(dòng)完成的,但沒(méi)有用
翻過(guò)高山走不出你
2023-04-21 16:55:36