select * from personal join information on personal.no = information.no join product on information.productid = product.product_idwhere informatio date=".$_POST["date"]."怎樣加上去上面的sql?
调试欢乐多
join information on personal.no = information.no
join product on information.productid = product.product_id
where information.date=".$_POST["date"].";
這句sql運行不到,哪裏出問題?
join information on(personal.no = information.no and information.date=".$_POST['date'].")
join product on(information.productid = product.product_id)"; 试一下
select * from personal join information on personal.no = information.no join product on information.productid = product.product_id where informatio.date=".$_POST["date"]."这样?
join information on personal.no = information.no
join product on information.product_id = product.product_id
where information.date='".$_POST['date']."'";
PS:字段名是否少写了个"_"