我希望将图片的文件路径和图像名称保存在同一个表中,当然是不同的字段。我怎样才能正确地执行它?我确信下面的代码中有一些明显的错误,但我找不到它。谢谢。
$sess_userid = mysql_real_escape_string($_SESSION['userid']);
$Image = mysql_real_escape_string($_FILES['file']['name']);
$PortraitPath = mysql_real_escape_string('profileportraits/' . $_FILES['file']['name']);
$query = "UPDATE Members
SET PortraitPath = '$PortraitPath'
WHERE fldID='$sess_userid'";
$query2 = "UPDATE Members
SET Image = '$Image'
WHERE fldID='$sess_userid'";
$result = mysql_query($query) or trigger_error(mysql_error().$query);
$result2 = mysql_query($query2) or trigger_error(mysql_error().$query2);发布于 2010-07-22 03:07:49
您可以同时更新同一表中的多个字段。
$query = "UPDATE Members
SET PortraitPath = '$PortraitPath',
Image = '$Image'
WHERE fldID='$sess_userid'";
mysql_query($query) or trigger_error(mysql_error().$query);发布于 2010-07-22 03:07:11
使用如下逗号:
UPDATE Members
SET PortraitPath = '$PortraitPath',
Image = '$Image'
WHERE fldID = '$sess_userid'https://stackoverflow.com/questions/3302815
复制相似问题