case "product_online":
$sql = "SELECT product_online FROM product WHERE product_id = '$product_id'";
$rs = mysql_query($sql);
$row = mysql_fetch_assoc($rs);
if($row['product_online']=='1'){
$sql = "UPDATE product SET product_online = '0' WHERE product_id = {$product_id}";
echo $row['product_online'].'+'.$product_id;
}
break;代码如上,echo $row['product_online'].'+'.$product_id; 能正确显示为 1+111111,可就是不执行product_online = '0'。
在mysql 命令行中 UPDATE product SET product_online = '0' WHERE product_id =111111 ,能成功更改product_online为0
$sql = "SELECT product_online FROM product WHERE product_id = '$product_id'";
$rs = mysql_query($sql);
$row = mysql_fetch_assoc($rs);
if($row['product_online']=='1'){
$sql = "UPDATE product SET product_online = '0' WHERE product_id = {$product_id}";
echo $row['product_online'].'+'.$product_id;
}
break;代码如上,echo $row['product_online'].'+'.$product_id; 能正确显示为 1+111111,可就是不执行product_online = '0'。
在mysql 命令行中 UPDATE product SET product_online = '0' WHERE product_id =111111 ,能成功更改product_online为0
https://blog.csdn.net/weixin_43421290/article/details/88717856
这句里的大括号{}改成单引号或者删了