$model = D('easAddUp_View');
$where['add_up_id'] = I('get.add_up_id');
$vo = $model->where($where)->select(); //这个正确会有数据
//$vo = $model->where($where)->find(); //这个不会出结果SELECT easAddUp.add_up_id AS add_up_id,easAddUp.mark AS mark,easAddUp.note_info AS note_info,easAddUp.add_up_date AS add_up_date,easAddUp.create_date AS create_date,easAddUp.dept_id AS dept_id,easAddUp.emp_id AS emp_id,empDept.dept_name AS dept_name,mupUser.user_name AS user_name,emp.name AS name,easDefItem.item_name AS item_name,easDefClass.class_name AS class_name FROM eas_add_up easAddUp JOIN emp_dept empDept ON easAddUp.dept_id=empDept.dept_id INNER JOIN mup_user mupUser ON mupUser.user_id=easAddUp.create_user_id INNER JOIN emp emp ON easAddUp.emp_id=emp.emp_id INNER JOIN eas_def_item easDefItem ON easDefItem.item_code=easAddUp.item_code INNER JOIN eas_def_class easDefClass ON easDefClass.class_code=easDefItem.class_code WHERE ( easAddUp.add_up_id = '1032' ) LIMIT 1
SELECT easAddUp.add_up_id AS add_up_id,easAddUp.mark AS mark,easAddUp.note_info AS note_info,easAddUp.add_up_date AS add_up_date,easAddUp.create_date AS create_date,easAddUp.dept_id AS dept_id,easAddUp.emp_id AS emp_id,empDept.dept_name AS dept_name,mupUser.user_name AS user_name,emp.name AS name,easDefItem.item_name AS item_name,easDefClass.class_name AS class_name FROM eas_add_up easAddUp JOIN emp_dept empDept ON easAddUp.dept_id=empDept.dept_id INNER JOIN mup_user mupUser ON mupUser.user_id=easAddUp.create_user_id INNER JOIN emp emp ON easAddUp.emp_id=emp.emp_id INNER JOIN eas_def_item easDefItem ON easDefItem.item_code=easAddUp.item_code INNER JOIN eas_def_class easDefClass ON easDefClass.class_code=easDefItem.class_code WHERE ( easAddUp.add_up_id = '1032' ) 区别是find有limit..为什么在这里limit会影响结果？不符合SQL语法？
最佳答案
