有人知道为什么这个语句不工作吗?我试图选择除了$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'");