|
发表于 2012-9-29 11:50:03
|
显示全部楼层
回 2312373360 的帖子
2312373360:但是会把member表中所有记录的m_activedate值都更新了,而不是把选中的企业的m_activedate更新! (2012-09-29 11:44)  是的,确实是这样
请修改为
elseif($do==\"refresh\"){
$db ->query(\"update {$cfg[\'tb_pre\']}hire,{$cfg[\'tb_pre\']}member set h_adddate=NOW(),m_activedate=NOW() where h_comid=m_id and h_id in ($members)\");
}elseif($do==\"republish\"){
$db ->query(\"update {$cfg[\'tb_pre\']}hire,{$cfg[\'tb_pre\']}member set h_adddate=NOW(),h_enddate=\'\".date(\'Y-m-d\',strtotime(date(\'Y-m-d\').\"+30 day\")).\"\',m_activedate=NOW() where h_comid=m_id and h_id in ($members)\");
} |
|