MySQL 查询执行错误 - MySQL Query Execution Error

MySQL Query Execution Error

本文关键字：错误执行查询 MySQL | 更新日期: 2023-09-27

我无法执行SQL查询，如下所示;

"Could not execute SQL query" SELECT * FROM tbl_fault WHERE id>0 AND `release`='2.70.000.04'

原因可能是，我正在使用mysql_real_escape_string，如下所示

if ($_REQUEST["releasenu"]<>'') {
$search_releasenu = " AND `release`='".mysql_real_escape_string($_REQUEST["releasenu"])."'"; }

mysql 数据库中的release列是 VARCHAR

需要建议！

亲切问候

将代码从

$search_releasenu = " AND `release`='".mysql_real_escape_string($_REQUEST["releasenu"])."'"; }

自

$search_releasenu = " AND release='".mysql_real_escape_string($_REQUEST["releasenu"])."'"; }

如上所述，从释放中去除 aprostrophe

试试这个：

if ($_REQUEST["releasenu"]<>'') {
$search_releasenu = " AND release='".mysql_real_escape_string($_REQUEST['releasenu'])."'"; }