没有,它指出是Unknown "Products" column in where 我在where语句中不用Products与OrderUser,而只用Orders就不会有问题
是这样的! "select * from Products left join Orders on Products.idProduct=Orders.idProduct left join OrderUser on Orders.idUser=OrderUser.idCustomer where Orders.fidShopper='$idBuilder_S' and (Products.idProduct like '%$keywords%' or Products.chrProductName like '%$keywords%' or OrderUser.chrShipFirstName like '%$keywords%' or Orders.dtOrder like '%$keywords%' or Orders.idBasket like '%$keywords%') order by dtOrder desc limit $startrow,$showrows";
我在where语句中不用Products与OrderUser,而只用Orders就不会有问题
"select * from Products left join Orders on Products.idProduct=Orders.idProduct left join OrderUser on Orders.idUser=OrderUser.idCustomer where Orders.fidShopper='$idBuilder_S' and (Products.idProduct like '%$keywords%' or Products.chrProductName like '%$keywords%' or OrderUser.chrShipFirstName like '%$keywords%' or Orders.dtOrder like '%$keywords%' or Orders.idBasket like '%$keywords%') order by dtOrder desc limit $startrow,$showrows";