帝国CMS批量修改ID范围数据的方法

//按ID范围批量修改发布者
$sql=$empire->query("select * from {$dbtbpre}ecms_article where id>85887 and id<145506 order by id limit $changeline");
while($r=$empire->fetch($sql))
{
$classid=$r['classid'];
$id=$r['id'];
$empire->query("update {$dbtbpre}ecms_article set userid=2,username='xzs' where  id>85887 and id<145506");
echo($id);
}