php - 使用 PHP 选择数据库中的最后一行不起作用

Question

我有一个 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;

知道如何解决吗？谢谢

Answer 1

问题是，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