各位前辈好:
我在PHP中写sql指令后于网站里执行:
$sql = "SELECT * FROM item WHERE shown = 1 , id LIKE '102%'";
echo $sql;
mysqli_query($conn, $sql);
echo mysqli_errno($conn) . ": " . mysqli_error($conn) . "\n";
执行结果如下:
SELECT * FROM item WHERE shown = 1 , id LIKE '102%'
1064: 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 ' id LIKE '102%'' at line 1
在网络上找的范例,对LIKE的条件也都是用单引号包起来的
但不晓得为什么在测试的时候就出现错误,感觉语法没有错...
请教各位前辈,是否我还有遗漏了什么东西
谢谢