update的代码如下:
$sql = "update BARGAIN set BARGAIN_STATE='".str_replace($old_value,$new_value,trim($search_array["BARGAIN_STATE"]))."',BARGAIN_PAY_MODE='".str_replace($old_value,$new_value,trim($search_array["BARGAIN_PAY_MODE"]))."',ADMIN_ID='".trim($search_array["admin_id"])."' ";
$sql.= " where BARGAIN_ID='".str_replace($old_value,$new_value,trim($search_array["BARGAIN_ID"]))."'";
$re=$conn->Execute($sql);
要择么写,才能往相同表里的另一个字段加值
$sql = "update BARGAIN set BARGAIN_STATE='".str_replace($old_value,$new_value,trim($search_array["BARGAIN_STATE"]))."',BARGAIN_PAY_MODE='".str_replace($old_value,$new_value,trim($search_array["BARGAIN_PAY_MODE"]))."',ADMIN_ID='".trim($search_array["admin_id"])."' ";
$sql.= " where BARGAIN_ID='".str_replace($old_value,$new_value,trim($search_array["BARGAIN_ID"]))."'";
$re=$conn->Execute($sql);
要择么写,才能往相同表里的另一个字段加值
字段里就有1和2两个值,这个sql要择么写?请各位高手指点
update table set a='2',b=(select b from table where id=xxx)+'2' where id=xxx
$sql = "update BARGAIN set BARGAIN_STATE='".str_replace($old_value,$new_value,trim($search_array["BARGAIN_STATE"]))."',BARGAIN_PAY_MODE='".str_replace($old_value,$new_value,trim($search_array["BARGAIN_PAY_MODE"]))."',ADMIN_ID='".trim($search_array["admin_id"])."' ";
$sql.= " where BARGAIN_ID='".str_replace($old_value,$new_value,trim($search_array["BARGAIN_ID"]))."'";
$re=$conn->Execute($sql); 按照您上面给的样式b=()里id是不是和下面where条件一样??