mysql语句执行WHERE NOT子句失败


Mysqli statement fails to execute WHERE NOT clause

有人知道为什么这个语句不工作吗?我试图选择除了$creator中的值之外的所有值,我知道该值已设置,因为查询下面的echo语句显示了值,

$this->res = mysqli_query($con,"SELECT * FROM escrow WHERE name !=$creator  "); 

我发现这是可行的:
$this->res = mysql_query("SELECT * FROM challenges_created WHERE name !='$creator'");

,但这是不工作:$this->res = mysqli_query($conn,"SELECT * FROM challenges_created WHERE name !='$creator'");

显然语法错误在后面的地方

试试这个:-

$this->res = mysqli_query($con,"SELECT * FROM escrow WHERE name !='$creator'");