/**
* 首页筛选操作
*
* @param $city int 城市地区
* @param $type int 工作类型
* @param $time int 工作时间
* @param $sex int 工作性别要求
* @author liupeng
*/
public function query(){
// 实例化model类
$job = M('jobtype');
$job = M('job');
// 构造查询条件
// $condition['jobName'] = $_POST['jobName'];
$condition['jobName'] = '礼仪';
$condition['place'] = array('like',"%".$_POST['place']."%");
// $condition['jobType'] = array('like',"%".$_POST['jobType']."%");
$condition['jobType'] = '3';
$condition['jobTime'] = array('like',"%".$_POST['jobTime']."%");
$condition['sex'] = array('like',"%".$_POST['sex']."%");
dump($condition);
// 计算总数
$count = $job->where(array('z_job.status' => 1,$condition))->count();
dump($count);
$Page = new \Think\Page($count,25);// 实例化分页类 传入总记录数和每页显示的记录数
foreach($condition as $key=>$val) {
$Page->parameter .= "$key=".urlencode($val)."&";
}
// 分页显示输出
$pages = $Page->show();
$result = $job
-> join('RIGHT JOIN z_jobtype ON z_job.jobType = z_jobtype.id')
-> field('z_job.id,z_job.jobName,z_job.jobType,z_job.number,z_job.jobTime,z_job.sex,z_job.salary,z_job.place,z_job.state,z_job.recommend,z_jobtype.jobtype')
-> where(array('z_job.status' => 1,$condition))
-> order(array('z_job.id' => 'desc'))
-> limit($page->firstRow.','.$page->listRows)
-> select();
dump($result);die;
// 赋值赋值
$this->assign('page', $page);
$this->assign('result',$result);
$this->display();
}报这个错SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'jobType' in where clause is ambiguous
请教各位大牛应该怎么写，如果不写搜索我这个sql语句可以用
最佳答案
