php - 错误 MySQL 服务器版本，在第 1 行 '' 附近使用正确的语法

Question

我想将我的 Web 应用程序嵌入到服务器，在本地主机中没有问题，但是当我放置我的应用程序并运行它时，出现了几个问题。

这就是问题

UPDATE HistoriKegiatan SET TglSelesaiPemberkasan = CURDATE(), WaktuSelesaiPemberkasan = CURTIME() WHERE IdHistori = 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 " at line 1

这是我的代码

$idKegiatan = (int) $_GET['idkegiatan'];
$NmKegiatan = $_GET['nmkegiatan'];
$transferto = $_POST['transferto'];

$catatan = $_POST['catatan'];
$tim = $_SESSION['team'];
$username = $_SESSION['user_name'];

$sql = "SELECT Max(IdHistori) as LastHId FROM HistoriKegiatan WHERE IdHistori IN (Select IdHistori from HistoriKegiatan where idKegiatan = $idKegiatan)";

    $result = dbQuery($sql);
    $no = dbNumRows($result);
    $data = dbFetchAssoc($result);
    $lastHId = $data['LastHId'];


$sql = "UPDATE HistoriKegiatan SET TglSelesaiPemberkasan = CURDATE(), WaktuSelesaiPemberkasan = CURTIME() WHERE IdHistori = $lastHId ";
echo $sql;
dbQuery($sql);

谁能帮我解决这个问题？抱歉我的英语不好

Answer 1

试试这个

$sql = "SELECT Max(IdHistori) as LastHId FROM HistoriKegiatan WHERE IdHistori IN (Select IdHistori from HistoriKegiatan where idKegiatan = '$idKegiatan')";

和

$sql = "UPDATE HistoriKegiatan SET TglSelesaiPemberkasan = CURDATE(), WaktuSelesaiPemberkasan = CURTIME() WHERE IdHistori = '$lastHId '";

它对你有用