同样的mysql语句
用命令行就可以执行
用mysql_real_query就报语法错
MySQL error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';' at line 1: /index.php query:UPDATE pointers SET account = account + 1 WHERE host = 'www.test.com';
用命令行就可以执行
用mysql_real_query就报语法错
MySQL error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';' at line 1: /index.php query:UPDATE pointers SET account = account + 1 WHERE host = 'www.test.com';
用命令行就可以执行
用mysql_real_query就报语法错MySQL error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';' at line 1: /index.php query:UPDATE pointers SET account = account + 1 WHERE host = 'www.test.com';其中一个语句从
mysql_real_query(mysql_handle, query,MAX_QUERY_LENGTH)
改为
mysql_real_query(mysql_handle, query,strlen(query) )
就可以正常执行了
接下来没任何操作就是另一个mysql_real_query语句
但是这个改了也没用了
----------------------------------------------------------
以下出现SQL syntax error :mysql_real_query(mysql_handle, query,MAX_QUERY_LENGTH)
mysql_real_query(mysql_handle, query,strlen(query) + 2)以下导致Segmentation fault :mysql_real_query(mysql_handle, query,strlen(query) + 1)
mysql_real_query(mysql_handle, query,strlen(query) )
-------------------------------------
分号那个问题只是我测试了一下而已
不用分号不正确才改了一下
出Segmentation fault 错的是其它地方