Home  >  Article  >  Backend Development  >  check the manual that corresponds to your MySQL server version for the right syntax的错误解析,correspondssyntax_PHP教程

check the manual that corresponds to your MySQL server version for the right syntax的错误解析,correspondssyntax_PHP教程

WBOY
WBOYOriginal
2016-07-13 09:52:081590browse

check the manual that corresponds to your MySQL server version for the right syntax的错误解析,correspondssyntax

错误原因一:SQL关键字冲突

分析:例:把desc命名为字段名

 

错误原因二:$right=$DB->fetch_one_array("SELECT rsnumber FROM ".$db_prefix."userright WHERE usertitle=".$usertitle"");

分析:.$usertitle.应该是这样的表示方式与数据库中的字段发生冲突,改成上图中的代码就可以了

(备注:个人拙见,希望有人补充!)

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/1010340.htmlTechArticlecheck the manual that corresponds to your MySQL server version for the right syntax的错误解析,correspondssyntax 错误原因一:SQL关键字冲突 分析:例:把desc命名...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn