Question

thinkphp sql语句问题

select * from user b,apply a where b.id=a.uid and ((b.check1=$id and a.state1=0) or (b.check2=$id and a.state1=1 and a.state2=0) or (b.check3=$id and a.state1=1 and a.state2=1 and a.state3=0))
转化成thinkphp的sql语句 table或者join都行
例：
$Model->table()->where()->select()
跪求高手解答

Answer 1

$user=M('user');
$where['_string'] = ' ((check1=$id and state1=0) OR (check2=$id and state1=1 and state2=0) OR (check3=$id and state1=1 and state2=1 and state3=0))';
$list=$user->join('apply ON user.id=apply.uid')->where($where)->select();
试看看，若两表没重复字段应该可以，不行再追问。

追问

我现在有点变化
select * from user b,apply a where b.id=a.uid and IF(a.dsum <2,b.check1=$id and a.state=0,(b.check1=$id and a.state1=0) or (b.check2=$id and a.state1=1 and a.state2=0) or (b.check3=$id and a.state1=1 and a.state2=1 and a.state3=0))
加了if判断

追答

你这个SQL语句能运行吗？

追问

可以呀~~mysql有if函数（判断条件，如果true就是这个参数，如果false就是这个参数）

追答

$user=M('user');
$where['_string'] = ' IF(dsum join('apply ON user.id=apply.uid')->where($where)->select();
你那个SQL能用，这个就能用。试看看。

怎么没有下文了？！