$user = M('Member');
$where['Member.username'] = session('username');
$where['Member.id'] = session('id');
$infocenter = $user->join(array('profile on profile.uid = Member.id'))->field('username')->where($where)->find();
echo $user->getlastsql();
$this->assign('infocenter',$infocenter);
打印出来的SQL语句
SELECT `username` FROM `pre_member` LEFT JOIN profile on profile.uid = Member.id WHERE ( Member.username = 'admin' ) AND ( Member.id = '3' ) LIMIT 1
最佳答案
