Home >Backend Development >PHP Tutorial >check the manual that corresponds to your MySQL server version for the right syntax error parsing, correspondssyntax_PHP tutorial

check the manual that corresponds to your MySQL server version for the right syntax error parsing, correspondssyntax_PHP tutorial

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

check the manual that corresponds to your MySQL server version for the right syntax error parsing, correspondssyntax

Error reason 1: SQL keyword conflict

Analysis: Example: Name desc as the field name

Error reason two: $right=$DB->fetch_one_array("SELECT rsnumber FROM ".$db_prefix."userright WHERE usertitle=".$usertitle"");

Analysis: .$usertitle. It should be expressed in this way and conflicts with the fields in the database. Just change it to the code in the picture above

(Note: My humble opinion, hope someone can add to it!)

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1010340.htmlTechArticlecheck the manual that corresponds to your MySQL server version for the right syntax error parsing, correspondssyntax error reason one: SQL Keyword conflict analysis: Example: Name 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