更新SQL dos'；不起作用.没有错误 - Update SQL doesn't work. No Error

Update SQL doesn't work. No Error

这是我的更新代码。它显示"完成"，但如果检查数据库，则字段不会更新。

我的代码出了什么问题？

<?php include('include/dbconnect.php');
$page = $_POST['newpage'];
$title = $_POST['newtitle'];
$content = $_POST['newcontent'];
$track_no = $_POST['track_no'];
$done = "UPDATE contents SET page = '$page',title = '$title', content = '$content', modified = 'CURDATE()'WHERE track_no = '$track_no' ";     
$result = mysql_query($done) or die(mysql_error());
if (!$result)
{
    print "Something is wrong!";
}
else{
    print "Done!";
}
?>

只需从sql 中删除引号

$done = "UPDATE contents SET page = '$page',title = '$title', content = '$content', modified = CURDATE() WHERE track_no = '$track_no' ";

你做得对，但只是愚蠢的错误，YOU SHOULD MUST REMOVE THE SINGLE QUOTE IN CURDATE就像

$done = "UPDATE contents SET 
page = '$page',
title = '$title', 
content = '$content', 
modified = CURDATE() 
WHERE 
track_no = '$track_no' ";

注意：任何类型的日期或时间都不要在报价中提及。不是这个0000-00-00 00-00-00