$mod = M('admin');
$validate = array(
array('username','require','帐户不能为空！'),
);
$mod->setProperty("_validate",$validate);
if(!$mod->create()){
$this->error($mod->getError());
} else {
$id = intval($_POST['id']);
$data['username'] = $_POST['username'];
if($_POST['password']){
$data['password'] = md5($_POST['password']);
}
$mod->where('id = ' . $id)->save($data);
echo $mod->getLastSql();
exit;
$this->success("修改成功！");输出查询语句发现语句有问题：UPDATE site_admin SET username='test' WHERE id = 2 ORDER BY rand()1=1
后面多了个order by rand()1=1，MSSQL执行这样的UPDATE语句会错误，怎么处理这样的错误啊？求教，谢谢。
最佳答案
