1.查询
$m=M("material_stored");
$name=$_POST["material_name"]; if($name!=""){ $where1["material_name"]=array(like,"%$name%"); } $where1['material_stored.matState']=1; $sql11="LEFT JOIN material_stored ON (new_mat_add.material_id=material_stored.material_idhao)"; //主表id=附表id //需要的 字段 $field1="material_stored.material_idhao as material_idhao,material_stored.material_name as material_name,material_stored.material_describe as material_describe,material_stored.matState as matstate, new_mat_add.add_time as add_time, mat_type.mattype_name as mattype_name, user.user_name as user_name"; $matHisAdd=M('new_mat_add')->join($sql11)->join($sql12)->join($sql13)->where($where1)->field($field1)->order('material_stored.material_idhao desc')->select(); $this->assign('matHisAdd',$matHisAdd);