sql問題

[kkwai]

select * from personal join information on personal.no = information.no join product on information.productid = product.product_id

where informatio date=".$_POST["date"]."怎樣加上去上面的sql？

[LIHY70]

select * from personal join information on personal.no = information.no join product on information.productid = product.product_id

where informatio date=".$_POST["date"]."怎樣加上去上面的sql？

select * from personal join information  on personal.no = information.no  join product on information.productid = product.product_id where informatio.date=".$_POST["date"]."

这样？

[frederic_zhao]

[Quote=引用 3 楼 kkwai 的回复:]
引用 2 楼 jakey9826 的回复:
SQL codeselect * from personal
join information  on personal.no = information.no
join product on information.productid = product.product_id
where information.date=".$_POST["date"].";


這句sql運行不到，哪裏出問題？
[/Quote]

显示的啥错误啊？

[总哈哈]

不懂楼主的意思！

[程序猿之殇]

select * from personal 
join information  on personal.no = information.no  
join product on information.productid = product.product_id 
where information.date=".$_POST["date"].";

[kkwai]

[Quote=引用 2 楼 jakey9826 的回复:]
SQL codeselect * from personal
join information on personal.no = information.no
join product on information.productid = product.product_id
where information.date=".$_POST["date"].";
[/Quote]

這句sql運行不到，哪裏出問題？

[meirenxing]

"select * from personal
join information  on(personal.no = information.no and information.date=".$_POST['date'].") 
join product on(information.productid = product.product_id)"; 

试一下

[DreamHK]

$str_sql="select * from personal 
join information  on personal.no = information.no  
join product on information.product_id = product.product_id 
where information.date='".$_POST['date']."'";

PS:字段名是否少写了个"_"