请问大家例如代码
SELECT A.a AS a, B.b AS b
FROM yshr, yskq
WHERE A.a = B.a
正常为什么执行
SELECT A.a AS a, B.b AS b
FROM yshr, yskq
WHERE A.a = B.a
AND B.b like "x"
就出错了呢?语句mysql下都运行正常 但在php网页中执行就页面报错?
SELECT A.a AS a, B.b AS b
FROM yshr, yskq
WHERE A.a = B.a
正常为什么执行
SELECT A.a AS a, B.b AS b
FROM yshr, yskq
WHERE A.a = B.a
AND B.b like "x"
就出错了呢?语句mysql下都运行正常 但在php网页中执行就页面报错?
SELECT A.a AS a, B.b AS b
FROM yshr A, yskq B
WHERE A.a = B.a吧
select A.a,B.b from A as a left jion或者right jion 或者 full jion on A.a = B.b//这里两个相同的字段值
连接表用on
select A.a,B.b from A as a left jion或者right jion 或者 full jion B as b on A.a = B.b//这里两个相同的字段值
连接表用on
连接表用on
写错了 应该是
SELECT A.a AS a, B.b AS b
FROM A, B
WHERE A.a = B.a
AND B.b like "123"问题是我的2个查询sql都测试通过 放在php网页上加上and后就报错了 不知道为什么
HTTP Error 500 (Internal Server Error): As unexpected condition was encountered while the server was attempting to fulfill the request.试了好几次 也看不出个所以然 所以想请教大家原因
; Log errors to specified file.
error_log = "C:\php.log"
重启apache,然后运行你的这个程序,看看php.log里有什么。
估计就是引号问题。