表1：sline_spot（id主键，ti
表2：sline_spot_ticket（spotid对应表1的id，ti
Model如下：
namespace Home\Model;
use Think\Model\ViewModel;
class spotModel extends ViewModel{
protected $viewFields = array(
'sline_spot'=>array('id','title','content','modtime','litpic','_type'=>'LEFT'),
'sline_spot_ticket'=>array('title'=>'classtitle','_on'=>'sline_spot.id=sline_spot_ticket.spotid'),
);
}Controller如下 $Model = D('Spot');
$id = $_POST['id'];
$data = $Model->field('id,content,title,modtime,classtitle')->select();
if ($data){
$res["code"] = 205;
$res["data"] = $data;
$res["msg"] = "查询成功";
$this->AjaxReturn($res);
} else {
$res["code"] = 206;
$res["data"] = "";
$res["msg"] = "查询失败";
$this->AjaxReturn($res);
}
}现在出现了报错，field里面不添加classti1054:Unknown column 'ticket_ti
[ SQL语句 ] : SELECT `id`,`content`,`ti
请教各位大神则么解决！？
最佳答案
