我有一个php代码，它将使用数据库选择mysql中的最后一行，但是会出现此错误：
syntax error, unexpected '$result' (T_VARIABLE)
我的PHP代码：
$con = mysqli_connect("localhost","root","","productno") or die("Error " . mysqli_error($con));
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con, "SELECT Alibaba FROM records ORDER BY Date DESC LIMIT 1");
if (mysqli_num_rows($result) > 0)
{
$s_Alibaba = mysqli_fetch_row($result);
$sql_Alibaba = $s_Alibaba[0]; //Compare with the last record
}
echo $sql_Alibaba;
知道如何解决吗？谢谢
问题是，date是mysql中的保留关键字。使用`字符将其转义：
$result = mysqli_query($con, "SELECT Alibaba FROM records ORDER BY `Date` DESC LIMIT 1");
看到这里：http : //dev.mysql.com/doc/refman/5.6/en/reserved-words.html
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句