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
Release: 2016-07-13 09:52:08
Original
1637 people have browsed it

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...
Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template