我想将我的Web应用程序嵌入到服务器中,在localhost中没有问题,但是当我放置我的应用程序并运行它时,存在一些问题。
这就是问题
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);
任何人都可以帮助我解决此问题?对不起我的英语不好
试试这个
$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 '";
它为你工作
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句