如题，同一句sql在php里执行没有结果，在navicat里查询有结果。
select top 25 shangpin.spdm, shangpin.spmc, guige1.ggmc as ys, sum (vw_sdlsmx.sl) as sl, fjsx3.sxmc as sheji, fjsx4.sxmc as dabanfrom shangpin, guige1, guige2, vw_sdlsmx, fjsx3, fjsx4where vw_sdlsmx.spdm = shangpin.spdmand vw_sdlsmx.gg1dm = guige1.ggdmand vw_sdlsmx.gg2dm = guige2.ggdmand vw_sdlsmx.dm1 != '900'and vw_sdlsmx.dm1 != '901'and shangpin.fjsx3 = fjsx3.sxdmand shangpin.fjsx4 = fjsx4.sxdmand vw_sdlsmx.spdm in ( select spdm from shangpin where byzd4 = '000' and byzd5 = 'eg')group by shangpin.spdm, shangpin.spmc, guige1.ggmc, fjsx3.sxmc, fjsx4.sxmcorder by sum (sl) desc

回复内容： 如题，同一句sql在php里执行没有结果，在navicat里查询有结果。
select top 25 shangpin.spdm, shangpin.spmc, guige1.ggmc as ys, sum (vw_sdlsmx.sl) as sl, fjsx3.sxmc as sheji, fjsx4.sxmc as dabanfrom shangpin, guige1, guige2, vw_sdlsmx, fjsx3, fjsx4where vw_sdlsmx.spdm = shangpin.spdmand vw_sdlsmx.gg1dm = guige1.ggdmand vw_sdlsmx.gg2dm = guige2.ggdmand vw_sdlsmx.dm1 != '900'and vw_sdlsmx.dm1 != '901'and shangpin.fjsx3 = fjsx3.sxdmand shangpin.fjsx4 = fjsx4.sxdmand vw_sdlsmx.spdm in ( select spdm from shangpin where byzd4 = '000' and byzd5 = 'eg')group by shangpin.spdm, shangpin.spmc, guige1.ggmc, fjsx3.sxmc, fjsx4.sxmcorder by sum (sl) desc

是不是没有 commit
打印出你的sql语句看下，可能传值的时候要加引号。如：变量='$...';
之前也遇到同样的情况，当时把语句复制到window s的记事本，再复制粘贴回回去，居然就好了。