如题，同一句sql在php里执行没有结果，在navicat里查询有结果。
<code>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</code>
回复内容：
如题，同一句sql在php里执行没有结果，在navicat里查询有结果。
<code>SELECT TOP 25 SHANGPIN.SPDM, SHANGPIN.SPMC, GUIGE1.GGMC AS YS, SUM (VW_SDLSMX.SL) AS SL, FJSX3.SXMC AS SHEJI, FJSX4.SX<div style="color:transparent">！本文来源gaodai.ma#com搞##代!^码网(</div><sup>搞gaodaima代码</sup>MC 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</code>
是不是没有 commit
打印出你的sql语句看下，可能传值的时候要加引号。如：变量=’$…’;
之前也遇到同样的情况，当时把语句复制到window s的记事本，再复制粘贴回回去，居然就好了。
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：sqlserver – 同一句sql在php里执行没有结果，在navicat里查询有结果是什么原因？
转载请注明原文链接：sqlserver – 同一句sql在php里执行没有结果，在navicat里查询有结果是什么原因？
