$query = "UPDATE TABLE1
SET (row1 = '$val1' WHERE row5 = '$someid' AND active = 'yes')
, (row1 = '$val2' WHERE row5 = '$someid' AND active = 'yes')
, (row1 = '$val3' WHERE row5 = '$someid' AND active = 'yes')";
mysql_query($query);
这个查询不做任何事情。我无法更新数据。
我做错了什么?
UPDATE `table` SET `name`= case `id`
when 1 then "Alex"
when 2 then "John"
when 3 then "Steve"
end
WHERE `id` in(1,2,3)
不是吗?
$sql_string='
UPDATE `TABLE1` SET `row1`= case `id`
when 1 then "'.$val1.'"
when 2 then "'.$val2.'"
when 3 then "'.$val3.'"
end
WHERE `row5 ` in('.$someid.','.$someid.','.$someid.') AND `active`= "yes"';
mysql_query($sql_string);
将以下代码添加到您的php文件中,您将了解哪里出错了
ini_set('display_errors', 1);
error_reporting(E_ALL);